Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the 2nd higgest salary in the column for example
take table name is employee?
And also find bottom 2nd lowest salary ?
- 11 Answers
- 15361 Views
- GeoTechnology, Wipro, I also Faced
- E-Mail Answers
Answer Posted / prasoon madnawat
SQL Server:
Select MIN(Salery) from (SELECT TOP 2 * from EMPLOYEE)
Oracle:
Select MIN(Salery) from (SELECT * from EMPLOYEE where ROWNUM <3)
MySQL
Select MIN(Salery) from (SELECT * from EMPLOYEE LIMIT 2)
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
12. Types of polymorphisem[Run and Design Exp.]
Explain about continuable exceptions?
Explain 'managed' mean in the .NET context
How do I know when my thread pool work item has completed?
How to improve the cache performance? : Dot net architecture
How to upload in video,mp4,in .net 4.5 ..?
What is the importance of updatepanel control?
can u give me real example of how web.config overrides the machine.config file?
How can we perform data binding in atlas?
what is polymorphism and advantage ?
Explain different pipelining hazards and how are they eliminated? : .NET Architecture
any one can explain about projectarchitecture and project approach briefly
Explain Intermediate Language?
What is the purpose of cache? How is it used? : Dot net architecture
What are the major differences between services and web services?
