Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 153849 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
How to handle a single quote in oracle sql?
How do I escape a reserved word in oracle?
How to use windows user to connect to the server?
How do I limit the number of oracle database connections generated by weblogic server?
What are the extensions used by oracle reports?
What is a cursor and what are the steps need to be taken?
master table and child table performances and comparisons in Oracle ?
What is null value in oracle?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
What is raw datatype in oracle?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Explain the use of tables option in exp command.
How to use fetch statement in a loop?
How to execute a stored program unit?
What privilege is needed for a user to connect to oracle server?
