Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / nripesh agarwal
select * from emp where salary=(select salary from emp
order by salary desc N,1);
// Put the value for N as for Nth highest salary
// e.g. for 2nd put N=2 , for 3rd put N=3 and so on...
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is the difference between drop and truncate commands?
What are the parts of a basic sql query?
What is a left join?
How do you modify a table in sql?
Which is better join or subquery?
What does stand for in sql?
What is left join in postgresql?
What is cost in sql execution plan?
How can we avoid duplicating records in a query?
What is scope and visibility in PL/SQL?
What is package in pl sql with an examples?
What is the purpose of a sql?
Is vs as in pl sql?
Explain what is rdbms?
Does a primary key have to be a number?
