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
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
What are the basic sql commands?
How to install oracle sql developer?
how to check myisam tables for errors? : Sql dba
what is the use of friend function? : Sql dba
what are date and time data types in mysql? : Sql dba
What are views in sql?
What is the maximum database size for sql express?
Is nosql faster than sql?
what is a database? : Sql dba
what is index? : Sql dba
What does select count (*) mean in sql?
How many primary keys can a table have?
Differentiate between pl/sql and sql?
What does the argument [or replace] do?