can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com
If you need the second highest salary only then following will also work, select Max(Salary) from TableName where Salary not in( Select Max(Salary) from TableName)