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 |
Explain about party and customer in ar : oracle accounts receivable
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
3. Steps in UAT?
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
1. What is PO rate variance gain and loss?
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
What do you mean by hz_ in customer tables? : oracle accounts receivable
What is autocashrule set? : oracle accounts receivable
which one is currently in used software cmpanies.
deference between & and &&
Explain materialized views and how they are used.