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 sqlexception in java?
What is an inconsistent dependency?
What is rollback?
Why do we need sharding?
what is the difference between blob and text? : Sql dba
Why are cursors used?
What is materialized view in sql?
Define concurrency control. : Transact sql
how can you see all indexes defined for a table? : Sql dba
Can a foreign key have a different name?
what is 'mysqlimport'? : Sql dba
Do ddl statements need commit?
Differentiate between % rowtype and type record.
what is oltp (online transaction processing)? : Sql dba
What is a primary key? Explain