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 the difference between layer and tier?
What is indexing and what are the different kinds of indexing?
What is 1 NF (Normal Form)?
What do data architects do?
What is Data Independence?
What is extension and intension?
What is one tier architecture?
What is 4NF?
What is a two tier wage system?
What do you know about system database? : sql server architect
What is database architecture? : sql server architect
What is difference between two tier and three tier?
Does storing of data in stored procedures increase the access time? Explain?
What is app tier?
What is msdb database? : sql server architect