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 is difference between stored function and application function?

603

What does select * from mean in sql?

2024

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

1652

How to run pl/sql statements in sql*plus?

601

What is normalisation in sql?

557

What is bind reference and how can it be created?

588

What is sql indexing?

565

What is tuple in sql?

549

Why do we use procedures?

529

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

575

Is it possible to sort a column using a column alias?

615

Explain dml and ddl?

559

What information is needed to connect sql*plus an oracle server?

596

how to select unique records from a table? : Sql dba

640

What are aggregate functions in sql?

641