how to retrieve the top 3 salaries of the table using rownum
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
What is range partitioning?
What is plpgsql language?
What is difference between mysql and postgresql?
how to use regular expression in pattern match conditions? : Sql dba
What is the use of nvl function?
What are the different operators available in sql?
Is left join inner or outer?
Where can I learn sql for free?
What are stuff and replace function?
What is bitemporal narrowing?
Why is %isopen always false for an implicit cursor?
What are different joins used in sql?
what are null values? : Sql dba
What is a primary key? Explain
what are the authentication modes in sql server? How can it be changed? : Sql dba