SELECT * FROM(SELECT * FROM EMP ORDER BY SAL DESC) WHERE ROWNUM<=3;

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

Question Posted / raghunanda

Answer Posted / raghunanda

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the parts of a sql statement?

1028

How many joins in sql?

945

How to get list of all tables from a database?

1107

How do I find duplicates in two columns?

1057

Can we join more than 2 tables in sql?

946

Does view contain data?

983

Is it possible to link two groups inside a cross products after the cross products group has been created?

953

Where not exists in sql?

911

differentiate between float and double. : Sql dba

988

How do you write a complex sql query?

1007

What does sign mean sql?

1020

How many types of indexes are there in sql?

933

What are user defined functions?

947

what are wild cards used in database for pattern matching ? : Sql dba

1076

What is %s in sql?

972