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
- 5430 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
What do you mean by hz_ in customer tables? : oracle accounts receivable
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
What is the disk migration? what is the steps involved in oracle disk migration?
types of receipts and detail desription about recipts and tables effected by receipts?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
Explain the use of table functions.
What is supporting issues GL AP and AR?
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
How would you determine who has added a row to a table?
What is the difference between oracle media recovery and crash recovery?
how to write customizations in po
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
please send me oracle pl/sql exp resume. and also faqs...
what are the tools used for oracle 10g in real time.
