Skip to Main Content
Forums

SQL & PL/SQL

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!

Specify order by clause to first order by specific value

cmit0227Jun 15 2006 — edited Jun 15 2006
Does anyone know how to specify an order by clause that first always orders by a particular value, and then follows next order by clause

for example.....

if my results of my query are 1, 3, 23 27, 31
and I always want 27 to come first, but then the rest in asc order....how can i do that?

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 13 2006
Added on Jun 15 2006
4 comments
1,997 views