how to retrieve the top 3 salaries of the table using rownum
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
Does sql*plus have a pl/sql engine?
What is a Mapplet?
Can we use ddl statements in stored procedure sql server?
how can we destroy the cookie? : Sql dba
Is pl sql a scripting language?
What is oracle sql developer?
Explain what is a column in a table?
How to check if a column is nullable before setting to nullable?
what are null values? : Sql dba
what is oracle database ? : Sql dba
What is rownum in sql?
What is pl/sql language case sensitive?
What is pl sql block structure?
What is sequence in sql?
what are properties of a transaction? : Sql dba