Answer Posted / nripesh agarwal
select * from emp where salary=(select distinct salary from
emp order by salary desc limit n,1)
// for Nth highest value put n=N-1....
//for 3rd highest put n=2........
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
What is union?
What is rtm stands for?
What is scalar function?
What is auto increment feature in sql?
What are secondary keys?
Which one is better subquery or joins?
What is sql deadlock?
How do I create a sql database?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
What kind of join is join?
What is the difference between microsoft sql and mysql?
What are the different types of sql commands?
Explain unique key in sql.
What are user defined functions?
How do I find duplicates in sql?
