File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes More than one orderyby Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "More than one orderyby" Watch "More than one orderyby" New topic

More than one orderyby

bala rajesh

Joined: Jul 31, 2006
Posts: 6
I want a "query" to retrive the data from one oracle table,
the conditions are one column orderby ascending order and another column orderby desc order. The two condition in a same query, is possible then reply me

Thanks in Advance

Stary Kapec
Ranch Hand

Joined: Dec 04, 2005
Posts: 81
FROM table_name
ORDER BY col_name1 ASC, col_name2 DSC
I agree. Here's the link:
subject: More than one orderyby
It's not a secret anymore!