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

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

Question Posted / chiru

Answer Posted / chiru

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are types of indexes in sql?

1065

What found sql?

932

What is difference between rank () row_number () and dense_rank () in sql?

1090

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1083

Is crud a cuss word?

1015

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

964

What are conditional predicates?

1034

What are the benefits of pl/sql packages?

1091

Which certification is best for sql?

974

how to decrement dates by 1 in mysql? : Sql dba

1007

What do you mean by dbms? What are its different types?

1001

Explain the savepoint statement.

1082

What is meant by temporal data?

945

What is recursive join in sql?

984

When is the explicit cursor used ?

1011