find out the third highest salary?
- 92 Answers
- 128802 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / vishal
Here is the correct query:
select ename,sal from emp e
where 3 = (select count(distinct(sal))+1 from emp
where e.sal < sal);
| Is This Answer Correct ? | 12 Yes | 5 No |
Post New Answer View All Answers
How to grant create session privilege to a user in oracle?
How to assign values to data fields in record variables?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
What is Virtual Private Database in Oracle?
Difference between hot backup vs. Cold backup?
definition of cluster and non-clustered index?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
How to check the server version in oracle?
How to invoke the data pump import utility?
Explain what are the characteristics of data files?
What is a database table in oracle?
Explain integrity constraint?
What exactly do quotation marks around the table name do?
How do I know if oracle is installed on windows?
What is an oracle user role?
