Find out the 3rd highest salary?
Answer Posted / sachin
select * from ( select * from (select * from emp order by
sal desc)
where rownum<=3
order by rownum desc)
where rownum=1
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
List the various privileges that a user can grant to another user?
how to shut down the server with 'mysqladmin'? : Sql dba
What do you mean by stored procedures? How do we use it?
What is sql server and ase?
What is range partitioning?
What is data control language?
What is sql partition function?
How do you rename a table in sql?
What is an example of translating a date into julian format?
What steps server process has to take to execute an update statement?
How to take user input in pl sql?
What is self-join and what is the requirement of self-join?
how do you tune the slow running queries in oracle db , explain the methodology
What is offset in sql query?
What is time based sql injection?