How to use IN statement with asc/desc in ORACLE queries?

arbab · September 20th, 2010, 02:22 AM

How to use IN statement with asc/desc in ORACLE queries?

Following queries worked properly, which are without IN statement:

1-SELECT ROLE,NAME,INSTITUTION
FROM ROLE
ORDER BY INSTITUTION ASC

2-Select Error, NAME,DESCRIPTION,FILE,CATEGORY
from errorcodes ORDER BY CODE ASC;

but when I use ORACLE query with IN it gives error, the query is:

3-SELECT *
FROM CUST
WHERE ORDER BY Channel IN ('0007', '9999','0001') ASC;

How can I write the above query properly?

Thanks in advance.

joefawcett · September 20th, 2010, 03:38 AM

I'm no Oracle expert but usually the IN operator is part of the WHERE clause:

Code:

SELECT * FROM CUST
WHERE Channel IN ('0007', '9999','0001')
ORDER BY Channel ASC;