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 |
which one is currently in used software cmpanies.
Where would you look for errors from the database engine?
What is database schema?
What is supporting issues GL AP and AR?
What is the mandatory setup in cyclecount ?
What are different types of receipt reversals ? Explain them : oracle accounts receivable
what is the difference between TRUNCATE and DELETE command in SQL
23 Answers ICICI, Saama Tech, SkyTech, TCS,
statement string in open is null or 0 length ORA-40735
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
What is difference b/w Credit memo and Adjustment in AR.
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
How would you go about increasing the buffer cache hit ratio?