2nd Highest Salary in SQL Server

2nd Highest Salary in SQL Server

  1. select MAX(ID) from Employees where ID NOT IN (Select MAX(ID) from Employees)
  2. select MAX(ID) from Employees where ID < (Select MAX(ID) from Employees )
  1. select top 1 ID from (select top 2 ID from Employees order by id descas tblEmployee order by ID ASC
  2.  Using dense_rank to retrieve 2nd Highetst salary if we have duplicate rows:
  3. with CTETable
  4. as
  5. (
  6. select ID, Name, DENSE_RANK() over (order by ID descas Rnk from Employees
  7. )
  8. select Name, ID from CTETable where rnk=2

How useful was this post?

Click on a star to rate it!

Average rating / 5. Vote count:

As you found this post useful...

Follow us on social media!

We are sorry that this post was not useful for you!

Let us improve this post!

Leave a Reply

Your email address will not be published. Required fields are marked *