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

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

Question Posted / manoj tcs

Answer Posted / manoj tcs

select * from (select * 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 different types of sql?

1161

How can you select unique records from a table?

1057

What is sql query optimization?

1093

What are procedures used for?

971

How do I add a primary key to a table?

1032

what are properties of a transaction? : Sql dba

1078

What does trigger mean in slang?

1036

What is the purpose of the partition table?

1036

what does the t-sql command ident_incr does? : Transact sql

1054

What is primary and foreign key?

1049

Is progress software supports to ( pl/sql )?

1029

Which sql most popular?

978

What is a string data type in sql?

1024

Explain two easy sql optimizations.

997

What is the difference between sql, mysql and sql server?

1070