how to retrieve the top 3 salaries of the table using rownum
- 31 Answers
- 36987 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
how to dump a table to a file with 'mysqldump'? : Sql dba
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 are the non-standard sql commands supported by 'mysql'? : Sql dba
What is the maximum number of triggers, you can apply on a single table?
what is index? : Sql dba
How do you modify a table in sql?
Which language is used in sql?
Is mariadb nosql?
Where not exists in sql?
Does group by remove duplicates?
What is the purpose of the sql select top clause?
What is left join in postgresql?
What do you understand by case manipulation functions?
Can procedure in package be overloaded?
what is a view? : Sql dba
