Comments by Virendra Maurya (Top 1 by date)

dear pandu

some update for u query

see this

SELECT
* FROM
( SELECT [Emp_Sal],[Emp_name],ROW_NUMBER() OVER(ORDER BY [Emp_Sal] DESC) As RowNum
FROM [MyDataDb].[dbo].[Employee_Test] ) As A WHERE a.RowNum IN (2)
for second highest salary .
thank's