find out the third highest salary?
Answer Posted / ajit
SQL QUERIES FOR FINDING Nth HIGHEST SALARY
SELECT DISTINCT (a.salary) FROM EMPLOYEES A WHERE &N = (SELECT COUNT (DISTINCT (b.salary)) FROM EMPLOYEES B WHERE a.salary<=b.salary);
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a trigger and what are its types?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
what is the scripts in data base?
What is a sub query? What are its various types?
What is a package in oracle?
Can a parameter be passed to a cursor?
Explain the use of compress option in exp command.
What is oracle thin client?
How to drop an existing table in oracle?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
 What are the oracle DML commands possible through an update strategy?
What is oracle update statement with inner join ?
How to create a new view in oracle?
How to compare dates in oracle sql?
What is a connect identifier?