Query to get second highest value from a table

This query is to get second highest salary from a table

select top1 salary from(select top2 salary from employee order by salary desc)employee order by salary asc

Happy Coding :)


No responses found. Be the first to comment...

  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: