HI,

I have a small question regarding the Order By clause. Please check the following query.

select
*
from
course
order by
course_name desc,title desc

and the output is as follows

Courseid ---- Tilte ---- course_name ---Duration
--------------------------------------------------------------
100168--MFC Fundamentals II-- wp202-- 15
100192--Win32 API Fundamentals II-- wp201-- 15
100121--MFC Fundamentals I-- wp102-- 15
100119--Win32 API Fundamentals I-- wp101-- 12
100281--UNIX Network Administration II-- ux700-- 8
100277--UNIX Network Administration I-- ux600-- 8
100227--UNIX System Administration I-- ux400-- 8
100573--Red Hat Linux Security (a)-- ux303-- 8
100326--Advanced UNIX Shell Programming-- ux301-- 10
100029--Creating Basic UNIX Shell-- sa0029-- 10
100582--Red Hat Linux Networking-- pm107-- 10
********************************************************************

if you observe the above result, in the query I have added two columns to the Order By clause. One is "Course_Name" and the other one is "Title". I want to sort both "Course_Name" and "Title" in descending order. But the query is taking only the "Course_Name" in descending order and ignoring the "Title" descending order.

If i try as follows
"select
*
from
course
order by
short_name,title desc"

now both the "Course_Name" and "Title" are sort by descending order.


How should I write query to get the output with two columns in descending order? Any mistake in my above query? Could you please help me regarding the same?

Thanks in advance.

Regards,
Srinivas Medukonduru