Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Difficult sort sql

843854Apr 14 2003 — edited Apr 16 2003
I want to select some records from a table and sort by

the concrete value of one column. For example:

select * from t order by id=1,id=5,id=10,id=0,id=4;

How to write the sql statement?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 14 2003
Added on Apr 14 2003
8 comments
146 views