how to find the 2nd higgest salary in the column for example
take table name is employee?
And also find bottom 2nd lowest salary ?
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 is .net mobile lists. Explain with an example? : Microsoft dot net mobile
Can you Explain <mobile:link> element .net mobile with example? : Microsoft dot net mobile
What happens to the winfx technologies?
Please tell me the .net 2.5 frame work with example
Differences between VS 2005, 2008 and 2010 ?
Explain the race around condition? : .NET Architecture How can it be overcome? : .NET Architecture
What is serialization, how it works in .NET?
What are .net mobile controls features? : Microsoft dot net mobile
What is Com Callable wrapper?when it will created?
what does dot in .net means
What is this DLL hell problem in dotnet? Can a virtual class be created/can a virtual method be created inside the class?
How can we perform data binding in atlas?