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
- 12503 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 |
Explain dma? : Dot net architecture
What is .net mobile input validation. : Microsoft dot net mobile
Is .net easier than java?
Explain the types of memory management? : .NET Architecture
Different types of authentication modes in .net framework ?
what are clr,cls,cts?what is .net framework?
what is sessions and cookies take one example simple way to understand
Explain hard disk and what is its purpose? : .NET Architecture
wild card character in sql ?
What is cache coherency? : Dot net architecture
how to manage session in webgarden ?
3 Answers Binary Logics, Ness Technologies,
What are different types that a variable can be defined and their scopes ?
Dot Net Framework 
