Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / nripesh agarwal
select * from emp where salary=(select salary from emp
order by salary desc N,1);
// Put the value for N as for Nth highest salary
// e.g. for 2nd put N=2 , for 3rd put N=3 and so on...
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is record data type?
How many triggers can be applied to a table?
What are sql*plus environment variables?
How to convert comma separated string to array in pl/sql?
Is nosql faster than sql?
What is interval partition?
What is sql deadlock?
what is 'mysqldump'? : Sql dba
What does a pl/sql package consist of?
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
What is not in sql?
Write a query to find the names of users that begin with "um" in sql?
Can you selectively load only those records that you need? : aql loader
how many columns can be used for creating index? : Sql dba
What are the rules to be applied to nulls whilst doing comparisons?
