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
- 13280 Views
- GeoTechnology, Wipro, I also Faced
- E-Mail Answers
Answer Posted / arrry.net
Select top 1 salary from tbl_registration where salary in
(SELECT TOP 2 salary from tbl_registration)
order by salary desc
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Different types of authentication modes in .net framework ?
What's the difference between an application and a program?
What is .net mobile input validation. : Microsoft dot net mobile
How to improve the cache performance? : .NET Architecture
How cache coherency is eliminated? : Dot net architecture
Define the mesi? : Dot net architecture
inprocess vs out process session state : Dot net architecture
.Net Frame work arch?
Explain the components required to develop mobile applications with .net mobile? : Microsoft dot net mobile
readonly syntax ?
Define cache? : Dot net architecture
Xmlserializer is throwing a generic "there was an error reflecting myclass" error. How do I find out what the problem is?
if there are two application 1 and 2 having a variable x in both app if client1 changes value of x in 1 app client 2 want reads the value of x from 2 app what resultant value will he get
Explain about httpruntime.cach.get(); method?
What is Opf3
