find out the third highest salary?
- 92 Answers
- 128813 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / saleem
select distinct(a.sal) from emp a where &3 = ( select count
(distinct(b.sal) from emp b where a.sal <= b.sal));
| Is This Answer Correct ? | 8 Yes | 6 No |
Post New Answer View All Answers
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How to get last row id?
What are oracle functions?
What is the relation of a user account and a schema?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What to do if the startbd.bat failed to start the xe instance?
Explain the use of file option in exp command.
Why is oracle database so popular?
What is background process in Oracle?
How to create id with auto_increment on oracle?
How many types of cluster table in Oracle?
Are truncate and delete commands same? If so why?
What is a system tablespace and when it is created?
Explain the importance of .pll extension in oracle?
How is it different from a normal table?
