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 the use of sqlerrd 3?
What is the use of double ampersand (&&) in sql queries? Give an example
What is difference between inner join and cross join?
How do rank () and dense_rank () differ?
How many indexes can be created on a table in sql?
how to check server status with 'mysqladmin'? : Sql dba
What is write ahead logging in sql server?
What is a call statement? Explain with an example.
What is the difference between a subquery and a join?
How does a covering index work?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
what are the performance and scalability characteristics of mysql? : Sql dba
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
List the different type of joins?
What is a string data type in sql?
