Interested to Buy Any Domain ? << Click Here >> for more details...
What is the sql query to find the employee who has Nth
maximum salary?
- 2 Answers
- 5245 Views
- I also Faced
- E-Mail Answers
Answer Posted / naweed ahmad
SELECT * FROM Emp E1 WHERE n-1 =
(SELECT COUNT(DISTINCT Sal) FROM Emp E2 WHERE E1.Sal <
E2.Sal)order by Sal desc
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
A scenario for amount correction & how to use amount correction functionality in AP invoices
What view would you use to determine free space in a tablespace?
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
types of receipts and detail desription about recipts and tables effected by receipts?
how to replace not in with not exist?
1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
default triggers available for reports
difference of using cursor for loop and open,fetch,close.which one is better
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
what are the tools used for oracle 10g in real time.
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.
what is difference between inner join & nested query or subqueries
key flexfield structure
