find out the third highest salary?
Answer Posted / sanil
select first_name,salary from employees a
where (select count(distinct(salary)) from employees aa
where a.salary<=AA.SALARY) = &n;
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
How to define default values for formal parameters?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What is a cursor variable?
What are operators in oracle?
How many types of synonyms in Oracle?
When do I need to use a semicolon vs a slash in oracle sql?
How to open a cursor variable?
candidate key is subset of super key but not vice-verse explain
How to put more than 1000 values into an oracle in clause?
Is there a combination of "like" and "in" in sql?
What is an oracle cursor variable?
How to create id with auto_increment on oracle?
What is concurrency in oracle?
What is where clause in oracle?
Which environment variables are absolutely critical in order to run the OUI?