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

Which certification is best for sql?

971

Will truncate release space?

926

what are the drivers in mysql? : Sql dba

1006

Can you call pl/sql package functions from within a fast formula?

1019

What is cost in sql execution plan?

962

What is break?

1180

How do you remove duplicate records from a table?

926

Explain the difference in execution of triggers and stored procedures?

1001

Does sql use python?

1013

What are the two parts of design view?

1003

What is the difference between delete, truncate and drop command?

1126

Is left join inner or outer?

1000

How can you fetch first 5 characters of the string?

996

What are the parameter modes supported by pl/sql?

1080

What is a primary key example?

941