select sal from (select distinct sal from emp order by sal desc ) where r

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

Question Posted / seema

Answer Posted / seema

select sal from (select distinct sal from emp order by sal
desc ) where rownum < 3;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is data types in sql?

983

Can instead of triggers be used to fire once for each statement on a view?

950

What does count (*) do in sql?

984

What is the use of sqldataadapter?

948

What is pls_integer in pl sql?

1074

What is a primary key called that is made up of more than one field?

1331

What do you understand by case manipulation functions?

1012

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1110

Is sql considered coding?

1027

How do you exit in sql?

1096

Explain what is rdbms?

1018

Explain the difference in execution of triggers and stored procedures?

1002

What will you get by the cursor attribute sql%found?

948

How to write a query to show the details of a student from students table whose

982

how many groups of data types? : Sql dba

1001