select sal from (select rownum,sal from emp order by sal desc) where row

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

Question Posted / akki julak

Answer Posted / akki julak

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

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I count duplicates in sql?

551

Does access use sql?

565

is mysql query is case sensitive? : Sql dba

565

How do you write a complex sql query?

589

What is sql not null constraint?

605

how to escape special characters in sql statements? : Sql dba

518

What is the difference between microsoft sql and mysql?

512

Explain what is a column in a table?

573

Is ms sql is free?

533

Explain the difference between rename and alias?

543

Does truncate free space?

520

Advantages and disadvantages of stored procedure?

581

Is vs as in pl sql?

494

Which is better join or subquery?

608

What is the file extension for sql database?

519