Hi,
How can I get second highest salary from a table.
Thanks, in advance
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Satyapriya NayakPosted Sep 13, 2011, 5:27 AM
Here is your Query
Select max(salary) from employee where salary NOT IN (Select max(salary) from employee)
Thanks
If this post helps you mark it as answer