how to retrieve the top 3 salaries of the table using rownum
Answer Posted / rajnish chauhan
you can put any number on Rnk.
---Top 3 salary
SELECT ROWNUM,ename,sal
FROM (
SELECT ename,sal,rank() over(ORDER BY sal DESC)rnk
FROM emp)a WHERE rnk<4
-----Top 3 Salary only
SELECT ROWNUM,ename,sal
FROM (
SELECT ename,sal,rank() over(ORDER BY sal DESC)rnk
FROM emp)a WHERE rnk=3
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are triggers in sql?
What is sharding in sql?
What is a design view?
What is sorting in sql?
What is difference between cursor and trigger?
Is postgresql a server?
How do I restart sql?
What are all the different types of indexes?
How do I filter in sql profiler?
What does sql stand for?
what is try_catch block in procedure
What is a field in a database?
What is a variable in sql?
What is crud diagram?
how many sql dml commands are supported by 'mysql'? : Sql dba