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
20343 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

What is PL/SQL ?

2069

What is the data pump export utility?

1081

Does oracle charge for java?

1058

How to import one table back from a dump file?

1025

How to create an oracle database?

1041

How to get a create statement for an existing table?

969

what is Single Byte Overhead...?

2555

What privilege is needed for a user to delete rows from tables in another schema?

1070

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1051

Can we convert a date to char in oracle and if so, what would be the syntax?

1016

What is a schema in oracle?

1014

How to assign a tablespace to a users in oracle?

1048

How to find the duplicate rows count from employees table in oracle?

1093

How to resolve the ORA-39133 error in Oracle?

1122

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

3331