a query to select maxmun 3 salaries of employee table
- 12 Answers
- 16628 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
How to define an oracle cursor variable?
How to display employee records who gets more salary than the average salary in the department?
How to fetch the row which has the max value for a column?
What are the built-in functions used for sending Parameters to forms ?
What is hash cluster in oracle?
How many file formats are supported to export data?
how to clone 9i Database on to 10g Database.
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
How to save query output to a local file?
How do we create privileges in oracle?
How many types of table in Oracle?
How to return top 5 rows in oracle?
How to connect to oracle using service name instead of sid?
What is the use of oracle?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
