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
- 13290 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
What is cache coherency and how is it eliminated? : .NET Architecture
What are the major differences between services and web services?
Can you explain atlasuiglitz library?
Explain difference between state server and sqlserver? : .NET Architecture
Whate are resource files? How are they used in .net?
What are the important principles of soa (service oriented architecture)?
How can we perform data binding in atlas?
Define cache coherency and how is it eliminated? : Dot net architecture
What is the difference between primary & secondary storage device? : Dot net architecture
Can I create my own context attributes?
What are public and private assemblies ?
What are relation objects in dataset?
What is the access level of the visibility type internal?
Can you explain server controls in atlas?
Does .NET runtime offer Deterministic Destruction or not?
