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

12 Answers
20185 Views
IBM, Polaris, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the use of owner option in exp command.

1022

What is the sql query to concatenate column values from multiple rows in oracle?

1034

What is backup in Oracle?

980

How do I spool in oracle?

979

Explain the use of file option in exp command.

1113

What is an oracle user account?

964

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2115

What is the database name in oracle?

1002

Difference between varchar and varchar2 data types?

1151

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2315

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2299

What is a proxy class?

1016

How to synchronize 2 schema's objects?

2147

How do I manually uninstall oracle client?

1066

What is difference between truncate and delete?

1017