how to retrieve the top 3 salaries of the table using rownum
- 31 Answers
- 33969 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / muneer ahamed
select rownum as rank,sal from (select rownum,sal from emp
order by sal desc)
where rownum<4
| Is This Answer Correct ? | 4 Yes | 5 No |
Post New Answer View All Answers
Is it possible to read/write files to-and-from PL/SQL?
How can you select unique records from a table?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
How do you determine the current isolation level? : Transact sql
Why do we use view in sql?
What company owns postgresql?
What is a constraint?
Is coalesce faster than isnull?
Can you call pl/sql package functions from within a fast formula?
What is clustered index in sql?
What is pl sql and why it is used for?
how to escape special characters in sql statements? : Sql dba
How you improve the performance of sql*loader? : aql loader
What is database white box testing and black box testing?
How can you fetch first 5 characters of the string?
