SELECT * FROM EMP A WHERE 1=(SELECT COUNT (*) FROM EMP B WHERE B.SAL>

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

Question Posted / nasir iqbal

Answer Posted / nasir iqbal

SELECT * FROM EMP A WHERE 1=(SELECT COUNT (*) FROM EMP B
WHERE B.SAL>=A.SAL)
SELECT * FROM EMP

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How do I run sql profiler?

1119

how to drop an existing index in mysql? : Sql dba

1114

What is a join query?

1007

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1244

How to pronounce postgresql?

1099

What are joins in sql?

1110

What is a string data type in sql?

1102

How many sql statements are used? Define them.

1081

What is full form of rtm?

1056

what is a join? : Sql dba

1085

How many types of sql are there?

1047

Is sql workbench free?

1047

What is dense_rank?

989

What is difference between nchar and nvarchar?

1103

Can we use threading in pl/sql?

1100