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.