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

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

Question Posted / k.thrilok kumar

Answer Posted / k.thrilok kumar

select rownum, sal from (select * from emp order by sal
desc) where rownum<=3

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Which constraints we can use while creating database in sql?

1058

how to enter numeric values as hex numbers? : Sql dba

1047

What is indexing in sql and its types?

1058

What do you mean by stored procedures? How do we use it?

983

Can we rollback after truncate?

1013

What is Materialized View? In What Scenario we Use Materialized View?

9485

Explain the working of foreign key?

1047

Is and as keyword in pl sql?

943

What is sql entity?

1077

Is mariadb a nosql database?

1036

What are the different set operators available in sql?

1009

What is not null in sql?

1036

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

939

how to use like conditions? : Sql dba

1087

What is t sql in sql server?

1055