can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com
In SQL Server 2000 Query: ------------------------- select max(salary) from Employee where salary not in(select max(salary) from employee) This Query only selects the 2'nd Higehest Salary in that table. So, you will try...