how to retrieve the top 3 salaries of the table using rownum
Answer Posted / debanjan rudra
select sal from (select sal from emp order by val desc)
where rownum < 4;
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How do I clear the screen in sql plus?
What is join view in sql?
What is data abstraction in sql?
What is an ndf file?
Why left join is used in sql?
What is sql basics?
how would you enter characters as hex numbers? : Sql dba
what is foreign key? : Sql dba
What is normalisation and its types?
Can 2 queries be executed simultaneously in a distributed database system?
How do I save a sql query?
What is file based approach?
Differentiate between pl/sql and sql?
Is it possible to link two groups inside a cross products after the cross products group has been created?
What is relationship? How many types of relationship are there?