how to find the fifth highest salary?
Answer Posted / saraswathi muthuraman
SQL> select * from emp_test order by sal desc;
1003 20010 11
1001 10000 11
1001 10000 11
1002 100 11
1004 99 11
1005 50 11
1006 25 11
SQL> select * from (select emp_no,dep_no,sal,rank() over
(order by sal desc) as rank_list from emp_test) where
rank_list =5;
1004 11 99 5
| Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
What is Set-at-a-time or Set-oriented?
What are the three levels of database architecture?
What is an Entity set?
What is a Phantom Deadlock?
What is DML Compiler?
What is 4NF?
What is "transparent DBMS"?
What is Fully Functional dependency?
How one call ddl statement using stored procedures in oracle?
What is Query evaluation engine?
What is end user data?
What are the the Advantages of DBMS?
What are the 3 levels of data abstraction?
State the different extensions for stored procedures?
Can we use commit inside the trigger? If not then how can we save the transaction made by the trigger?