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
- 15621 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 is the difference between l1 and l2 cache? : Dot net architecture
How can a win service developed in .NET be installed or used in Win98?
What is serialization, how it works in .NET?
which tag i need to use manually to bind columns in a datagrid ?
how would you manage data if u were not to use sessions or cookies ?
What is Opf3
Differences between VS 2005, 2008 and 2010 ?
So what exactly is the configuration file for then?
what is diffrent beatween localprinter and networkprinter
what is the method while we are using adapter and dataset ?
How to develop mobile applications using microsoft mobile internet toolkit (mmit) or .net mobile? : Microsoft dot net mobile
Difference between type constructor and instance constructor?
Dot Net Framework 
