select empno, ename, sal from (select * from emp order by sal desc) where

how to retrieve the top 3 salaries of the table using rownum

Question Posted / vik

Answer Posted / vik

select empno, ename, sal from (select * from emp order by
sal desc) where rownum < 4

Is This Answer Correct ?

8 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are sql ddl commands?

1073

What are different types of statements supported by sql?

1147

what are date and time data types in mysql? : Sql dba

953

What is sql*loader and what is it used for? : aql loader

1145

What is sqlite used for?

980

What is full join in sql?

973

what is a composite primary key ? : Sql dba

1025

what are integrity rules?

1010

What is vector point function?

1026

What is raw datatype in sql?

1029

what is the difference between a local and a global temporary table? : Sql dba

1045

What are the types of queries in sql?

1065

how to include character strings in sql statements? : Sql dba

1046

what is sql? : Sql dba

1002

what is text? : Sql dba

1058