Do You Know How to select the nth(for ex : 10th) largest number in a column without using max() function..
I am using orderid column from orders table in nortwind database for example

[sql]select top 1 * from(select top 10 orderid from orders order by orderid desc)a order by orderid asc[/sql]

By : Krishna Prasad J
krishnaprasad.jk@gmail.com