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
- 15756 Views
- GeoTechnology, Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to implement the display in the class printdoc (how to resolve the naming conflict) a: no naming conflicts
What is difference between .net and visual studio?
Name some changes done since version 3.0?
What is .net mobile images control. : Microsoft dot net mobile
What is .net mobile input validation. : Microsoft dot net mobile
8. Oop-Why and were we use Interfacse and Abstract class.
Define an interrupt? : Dot net architecture
How to improve the cache performance? : Dot net architecture
What is IL code, CLR, CTS, GAC & GC?
How can I create a application?
Describe the advantages of writing a managed code application instead of unmanaged one. What is involved in certain piece of code being managed?
Define domestic architecture artifacts? : Dot net architecture
What is .net mobile input validation. Explain with an example? : Microsoft dot net mobile
Explain the components required to develop mobile applications with .net mobile? : Microsoft dot net mobile
how can we achieve language interoperability through CLS? How MSIL works?
