Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrieve the top 3 salaries of the table using rownum
- 31 Answers
- 42832 Views
- Oracle, I also Faced
- E-Mail Answers
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
Can we rollback after truncate?
What is sql select statement?
What is a sql profiler?
Can we join 3 tables in sql?
Is sql a scripting language?
What are tuples in sql?
how to rename an existing column in a table? : Sql dba
What is a .db file?
What is query syntax?
What are inner and outer joins examples of both?
what are the performance and scalability characteristics of mysql? : Sql dba
How many types of indexes are there in sql?
What is input buffer in sql*plus?
what is a primary key? : Sql dba
What does the file extension accdb stand for?
