Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 148801 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / sanjeev kumar p
select * from emp e1 where (3-1) = (select count(distinct
(e2.sal)) from emp e2 where e2.sal>e1.sal)
| Is This Answer Correct ? | 99 Yes | 51 No |
Post New Answer View All Answers
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 clone 9i Database on to 10g Database.
How do I uninstall oracle 11g?
How to execute the package in oracle?
What is the difference between PFILE and SPFILE in Oracle?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
What is the difference between translate and replace in oracle?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is parameterized cursor in oracle?
What is bulk load in oracle?
What is index-organized table in Oracle?
How to change system global area (sga) in oracle?
Hi Can any one tell me what are the API's used in requisition import.
What is meant by joins?
How to join two tables in a single query using oracle?
