Interested to Buy Any Domain ? << Click Here >> for more details...
How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
- 35 Answers
- 58866 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
Answer Posted / vinay singh
To find any number of Salary..
Select * From Table E1 Where
(n-1) = (Select Count(Distinct(E2.Sal)) From Table E2
Where E2.Sal> E1.Sal)
**Vinay Singh
| Is This Answer Correct ? | 8 Yes | 12 No |
Post New Answer View All Answers
Can we insert data into a view?
Why should you use or avoid select * statements?
How to get nth highest salary from employee table.
Explain can SSRS reports Cache results?
A trigger can reference objects outside the current database? State true or false.
What is the importance of concurrency control?
Which Model uses the SET concept
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
What are the types of resultset?
Why do we need different type of parameter?
Why use “nolock” in sql server?
What is thr feature of change data capture?
Mention the uses of stored procedures.
How to name query output columns in ms sql server?
Can you insert NULL in unique column?
