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
- 60270 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
What are the types of normalization?
What is the difference function and stored procedure?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
What are the different types of collation sensitivity?
Do I need a report server to run reports in my application?
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
What are types of storage modes? : sql server analysis services, ssas
What stored by the master?
What is nonclustered index with included columns ?
What is @@rowcount in sql?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
What is service broker?
What according to you is the difference between mysql and sql server performance?
How many types of stored procedures are there in sql server?
Can we insert data if clustered index is disabled?
