wood burning stoves 2.0*
The moose likes JDBC and the fly likes sorting multiple columns Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "sorting multiple columns" Watch "sorting multiple columns" New topic

sorting multiple columns

Shiv Sidhaarth
Ranch Hand

Joined: Aug 06, 2001
Posts: 119
How do i sort multiple columns in Oracle using lower? ie. When i say, lower(Name), result is like this :
I want to give first Name as well as last name in sorting with lower. Hope i am clear.
prabhat kumar
Ranch Hand

Joined: Apr 11, 2001
Posts: 114
order by tolower(colname)
Leslie Chaim
Ranch Hand

Joined: May 22, 2002
Posts: 336
order by lower(first_name || last_name)

Normal is in the eye of the beholder
It is sorta covered in the JavaRanch Style Guide.
subject: sorting multiple columns
Similar Threads
Using Display Tag for multiple column sorting (secondary sorting)
How To Sort Multiple Columns
Thanks all. I passed!
STRUTS1.1 sorting data in a html table based on the combination of columns
sorting functionality in jsp