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
- 5346 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 |
Describe the P2P cycle ?
what is correlated subquery
What is the use of lockboxes? : oracle accounts receivable
what is semphore explian it?
What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Olap tools
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
how to write customizations in po
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
Give the reasoning behind using an index.
Oracle General 
