how to retrieve the top 3 salaries of the table using rownum
- 31 Answers
- 36930 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / rameshwar gupta
select ename ,sal from (select ename,sal from emp order
by sal desc)
where rownum<4
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
Can we use view in stored procedure?
what is normalization? : Sql dba
Does postgresql run on the cloud?
What are field types?
When can we use the where clause and the having clause?
What is primary and foreign key?
how to get a list of columns in an existing table? : Sql dba
What are different types of functions in sql?
How can we store rows in PL/SQL using array?
What programs use sql?
what is offset-fetch filter in tsql? : Transact sql
How can triggers be used for the table auditing?
What is join view in sql?
how would you get the current date in mysql? : Sql dba
What is compilation error in pl sql?
