Hi suresh_yaram,
quote:
I have an employee table having empno , salary. How to find 2 nd highest salary thru t-sql query
what about
SELECT TOP 1 salary FROM employee WHERE salary < (SELECT MAX(salary) FROM employee) ORDER by salary DESC
??
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]