Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 147556 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / suresh kumar
Hi every body,
I give the standard format Query for this type of top most
and who are the top n people in the organization like that
If we take EMP table
Select * from EMP A where &n= (select count (distinct
(sal)) from EMP B where B.sal>A.sal)
If we give n value 1 or 2 or 3….etc then we gets top one,
top second, and top third person details.
This same query can we use top n people who are earning
maximum salaries in the Organization
Select * from EMP A where &n> (select count (distinct
(sal)) from EMP B where B.sal>A.sal)
| Is This Answer Correct ? | 38 Yes | 19 No |
Post New Answer View All Answers
How translate command is different from replace?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
How can we view last record added to a table?
How to convert raw data type into text in oracle? Explain
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
Why do you create or replace procedures rather that drop and recreate.
How to display employee records who gets more salary than the average salary in the department?
Difference between oracle's plus (+) notation and ansi join notation?
Is there a function to split a string in plsql?
How data locks are respected in oracle?
Explain the difference between a procedure and a function?
What happens if you lost a data file?
Give the advantages and disadvantages of clusters.
types of indexes and the rationale behind choosing a particular index for a situation.
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
