Interested to Buy Any Domain ? << Click Here >> for more details...
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
Is sql an operating system?
Does a primary key have to be a number?
How do I run sql profiler?
What sql does db2 use?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is recursive join in sql?
what are all the different types of indexes? : Sql dba
What are the different tcl commands in sql?
Where can I learn sql for free?
What is not equal in sql?
how can we destroy the session, how can we unset the variable of a session? : Sql dba
Define a temp table?
What is a behavioral trigger?
What is character functions?
How to create an array in pl/sql?
