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

What is parallel hint?

1332

how to see the create table statement of an existing table? : Sql dba

1021

how can we know the count/number of elements of an array? : Sql dba

1066

Mention what are the benefits of pl/sql packages?

1086

What does joining a thread mean?

1023

Can a procedure in a package be overloaded?

1047

how to enter characters as hex numbers? : Sql dba

1047

Why is stored procedure faster than query?

966

What is a pdo connection?

1050

what is row? : Sql dba

1230

Why trigger is used in sql?

977

what is schema? : Sql dba

1051

Can dml statements be used in pl/sql?

1087

What is indexing in sql and its types?

1083

how mysql optimizes distinct? : Sql dba

1083