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 does an inner join do?

1188

What is trigger types in sql?

996

what are the features and advantages of object-oriented programming? : Sql dba

1012

Explain what is table in a database?

1062

What does sign mean sql?

1120

Do we need to rebuild index after truncate?

1036

What are the types of subqueries?

1055

What is sql basics?

1046

Enlist the advantages of sql.

1002

Is pl sql different from sql?

1002

What is a mutating table and a constraining table?

1117

What is a sql*loader control file?

1271

Can we create table in function?

968

What is an ndf file?

994

How do I create a sql script?

1103