"ORDER BY" question

[Cantor]

Hi,

Let suppose a single table NAMES

First_name VARCHAR2
Last_name VARCHAR2

Is it possible to do a query to show this table ordered by First_name first and, secondly, ordered by descending order of the Last_name in the same query?

thanks

 

[r937]

[tt]select First_name
, Last_name
from NAMES
order
by First_name ascending
, Last_name descending[/tt]

so this gives you

Adam Sandler
Andy Richter
Bill Maher
Bret Hull
etc.


rudy