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
- 16092 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 stage management ? (ASP.NET)
What is VSS? Use of VSS? How can we use VSS in our Application?
what are clr,cls,cts?what is .net framework?
Explain about metadata?
what is polymorphism and advantage ?
Explain the difference between inprocess vs out process session state : Dot net architecture
Explain how to develop mobile applications using microsoft mobile internet toolkit (mmit) or .net mobile? : Microsoft dot net mobile
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 GeoTechnology, Wipro,
2. What type of code (server or client) is found in a Code-Behind class?
How does .net remoting work?
How to call .NET Web service from Java Appl. & Why ?
what is a namespace?how they are classified?write a program which contains class,object,inheritance?
Dot Net Framework 
