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
- 16068 Views
- GeoTechnology, Wipro, I also Faced
- E-Mail Answers
Answer Posted / prasoon madnawat
i forgot order by in da last post
SQL Server:
Select MIN(Salery) from (SELECT TOP 2 * from EMPLOYEE order
by Salery DESC)
Oracle:
Select MIN(Salery) from (SELECT * from EMPLOYEE where ROWNUM
<3 order by Salery DESC)
MySQL
Select MIN(Salery) from (SELECT * from EMPLOYEE order by
Salery DESC LIMIT 2)
likewise for 2nd minimum salery.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
how to set the startup position of the form?
What is the mesi? : .NET Architecture
Explain dotnet framework ?
Explain about developer benefit from memory management?
What is IL code, CLR, CTS, GAC & GC?
What is difference between .net and visual studio?
Explain the five stages in a dlx pipeline? : .NET Architecture
What is .net mobile input validation. Explain with an example? : Microsoft dot net mobile
Define a virtual memory? : Dot net architecture
what are login controls?
where should I put this information then?
What is an interrupt? : Dot net architecture
What is .net mobile forms? : Microsoft dot net mobile
any one can explain about projectarchitecture and project approach briefly
How can we integrate atlas with web services?
