Ruwan's techno Blog
Saturday, May 11, 2019
Get the third highest salary in the employee table - SQL
This is my Table, and I want to get the 3rd highest salary
First lets sort the table by salary in descending order
Then to get the 3rd highest. Set offset to 2 and get only one line by setting limit to 1.
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment