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
Is oracel sql developer written in java?
What does rownum mean in sql?
What is composite data type in pl sql?
What are the types of views in sql?
How do I remove duplicates in two columns?
What is mdf ldf and ndf?
Explain the types of joins in sql?
Explain ttitle and btitle.
What are the types of operators available in sql?
What is a natural join sql?
What are analytic functions in sql?
Can we have two clustered index on a table?
What does sign mean sql?
explain commit and rollback in mysql : sql dba
describe transaction-safe table types in mysql : sql dba