Win a copy of Java 9 Revealed this week in the Features new in Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

More than one orderyby  RSS feed

 
bala rajesh
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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

Bala
 
Stary Kapec
Ranch Hand
Posts: 81
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
SELECT *
FROM table_name
ORDER BY col_name1 ASC, col_name2 DSC
 
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!