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
- 5238 Views
- I also Faced
- E-Mail Answers
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 |
Can We Restore a Table that accidantly dropped.
What command would you use to create a backup control file?
What is Virtual Memory?
which one is currently in used software cmpanies.
Explain an ORA-01555
What is an Oracle database Partial Backup?
Explain prerequisites and post activities of oracle database installation
can u give guidance abt packages of plsql
How do you create a credit note against an invoice? : oracle accounts receivable
What is the architectural difference between Oracle and SQL Server 2000? If I have 100 databases, how many instances get created when you use Oracle and how many get created when you use SQL Server?
how to get the values if source table & target table having duplicate values that matches the lookup condition ?(i want all duplicate match)
I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer
Oracle General 
