SELECT E1.ENAME,E1.SAL FROM EMP E1 WHERE 3>(SELECT COUNT(*) FROM EMP E2

a query to select maxmun 3 salaries of employee table

Question Posted / krishna kumar r

Answer Posted / krishna kumar r

SELECT E1.ENAME,E1.SAL FROM EMP E1 WHERE 3>(SELECT COUNT(*)
FROM EMP E2 WHERE E2.SAL>E1.SAL ) ORDER BY SAL DESC

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the different types of modules in oracle forms?

1047

How to drop an existing table in oracle?

1102

State the various uses of dbcc command?

1105

What is the difference between substr & instr functions?

1293

Differentiate between function and procedure in oracle.

1154

What is a select query statement in oracle?

1027

What are the restrictions on external table columns?

1109

Explain a data segment?

1112

Explain the use of rows option in exp command.

1147

How to fetch the row which has the max value for a column?

1044

What is format trigger?

2120

What is a package ? What are the advantages of package ?

1136

What is an oracle database table?

1062

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

2066

What is the order of defining local variables and sub procedures/functions?

1113