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

Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
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
Similar Threads
Improving EJB performance
Once again JAVA-ORACLE
How to retain order of list?
Recent Transaction Records
sorting problems in struts jsp