a query to select maxmun 3 salaries of employee table
- 12 Answers
- 16880 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
Can we connect to ORACLE db using Windows Authentication?
What is a proxy class?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
How to use "out" parameter properly?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
Can we write insert statement in function in oracle?
Explain rename?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
What are the advantages of oracle?
Does oracle partitioning improve performance?
What is a static data dictionary in oracle?
How to estimate disk space needed for an export job?
How to apply filtering criteria at group level in oracle?
What is an index associated with a constraint?
Calculate difference between 2 date / times in oracle sql?
