Bineesh  Viswanath

Bineesh Viswanath

  • NA
  • 1k
  • 777.4k

Display Second highest value in a Table in SQL Server

Jun 6 2013 11:26 PM
Sir, I have a table name tbl_Employee

the contents are:-

emp.ID                     Name                        Salary

   05                         John                           5000
   08                         Rose                           4000
   10                         Mathew                       6000

I want to display emp.Id ,Name and Salary of employee whom salary is second highest in this table

please send me the SQL Query

Answers (4)