What is the sql query to find the employee who has Nth
maximum salary?
Answers were Sorted based on User's Feedback
Answer / naresh
Select * From TableName T1 Where
(N-1) = (Select Count(Distinct(E2.ColumnName))
From TableName T2 Where T2.ColumnName > T1.ColumnName)
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Is there any link between pr form(purchse requisition)and po form(purchase order)
What is $FLEX$ and $PROFILES$?
what are basic modules required to implement oracle application in any oraganisation?
HOW TO SPOT AHIERARCHY?
Why more redos are generated when the oracle database is in begin backup mode?
Are These Dff's Flexible?
What is db_recovery_file_dest in oracle? When do you need to set this value?
Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?
How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun
Why we are using primary key and foreign key in oracle and difference between primary key and foreign key?
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
How to clone the database using RMAN back