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
- 15360 Views
- GeoTechnology, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
What are end points, contract, address and bindings?
Explain dotnet framework ?
where should I put this information then?
The maximum report processing jobs limit configured by your system administrator has been reached.How I can Solve this problem when i using crystal report to load from my application.
12. Types of polymorphisem[Run and Design Exp.]
Explain what does the term "green architecture" mean? : .NET Architecture
Does application frame need host?
Waht is Dot net Arcitecture
State the different levels of exceptional safety?
Explain about httpruntime.cach.get(); method?
Explain the use of virtual, sealed, override, and abstract.
how to change the title of my window?
Dot Net Framework 
