how to retrieve the top 3 salaries of the table using rownum
- 31 Answers
- 36988 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / kavitha
select employee_id,last_name,salary
from employees
where rownum <=3
order by salary desc
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Which is better cte or subquery?
How to disable a trigger name update_salary?
what are rollup and cube in t-sql? : Transact sql
What is cursor and why it is required?
How to revise and re-run the last sql command?
What is partition in sql query?
Define sql delete statement.
Why do we use triggers?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
What does select * from mean in sql?
What is the use of %rowtype?
What is the difference between delete, truncate and drop command?
What is data type in database?
How do you exit in sql?
what is the difference between cluster and non cluster index? : Sql dba
