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
- 13282 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 |
How cache coherency is eliminated? : Dot net architecture
What is .net mobile images control. : Microsoft dot net mobile
can aspx page have multi language declarations ?
What is cache coherency and how is it eliminated? : Dot net architecture
5. Wcf- Session Managment
Is dim fs as filestreamobject is a managed code? : Dot net architecture
What is different about namespace declaration when comparing that to package declaration in java?
What is gui programming? : .NET Architecture
What is a virtual memory? : Dot net architecture
Explain .net mobile selectionlist control? : Microsoft dot net mobile
Which Binding best suits where a WCF Service and the client application resides in the same machine?
hi, kindly send WWF(.net 3.5) pdf notes to my id. thanx in advance, chays
Dot Net Framework 
