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

Syed Arbab Ahmed

16y19.2kOracle

How to use IN statement with ORDER BY 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.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manikavelu Velayutham16y ago
Accepted answer
Replace your query by this following query, it will execute
SELECT *
FROM CUST
WHERE Channel IN ('0007', '9999','0001') ORDER BY Channel ASC;
+1
Suthish Nair16y ago
I dont know what you trying to do, but as per my understanding you want to sort your rows basis of Channels.
try this..
select * from
(
select rownum, a.* from cust a where channel in ('0007', '9999','0001')
)
order by rownum desc;

+1
Noushad Moh16y ago
Select * from cust where custname in ('ABC','DEF','GHI') order by Channel

+1