how to retrieve the top 3 salaries of the table using rownum
Answer Posted / akki julak
select sal from (select rownum,sal from emp order by sal
desc)
where rownum<4;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the operators used in select statements?
What are actual parameters and formal parameters?
Is natural join and inner join same?
What does closing a cursor do?
Can triggers stop a dml statement from executing on a table?
what is sp_pkeys? : Transact sql
How does an execution block start and end in pl sql?
What is before trigger?
Define SQL and state the differences between SQL and other conventional programming Languages?
What does where 1/2 mean in sql?
How do I find duplicates in the same column?
What is a recursive stored procedure?
Which are the different case manipulation functions in sql?
How to display Row Number with Records in Oracle SQL Plus?
How do I run a sql query in pgadmin 4?