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 a table in a database ? : Sql dba
Can we use join in subquery?
Can a foreign key have a different name?
what is a foreign key ? : Sql dba
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
how to start mysql server? : Sql dba
how can we destroy the session, how can we unset the variable of a session? : Sql dba
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
What are the types of index in sql?
What is bind reference and how can it be created?
How do I start pl sql?
What are the different dml commands in sql?
How to handle bulk data?
what are null values? : Sql dba
How can you know that statistics should be updated?