can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com
SELECT Min(Sal) FROM (SELECT TOP 2 Sal FROM emp ORDER BY Sal desc) as Temp or SELECT Min(Sal) FROM emp WHERE Sal IN(SELECT TOP 2 Sal FROM emp ORDER BY Sal DESC)
Site Map
