How to dispaly ascending and descending order in a single SQL query ?

[Guest_imported]

Hi

Please hlep me how to display one column in ASC and another column in DESC order in a single query ?

Here is what I want....

The actual data is like this....

Name Friend_name
-------------------
raj srinivas
arvind raghu
venkat charan
sekhar dev
sami arjun

I want the output like this....

Name Friend_name
-------------------
arvind srinivas
raj raghu
sami dev
sekhar charan
venkat arjun


Thanks
Suja

 

[moonshadow]

Order by Name asc, Friend_Name desc

 

[Andel]

Here's how you do it.


SELECT A.name, B.friend_name
FROM (select name, Id = (select Count(name) from Friends where name <= f.name)
FROM friends f) A
JOIN (select friend_name, Id = (select Count(friend_name) from Friends where friend_name >= f.friend_name)
FROM friends f) B on A.Id = B.Id
ORDER BY A.NAME


Andel
andel@barroga.net

http://andyb.8m.com