how to find the 2nd higgest salary in the column for example
take table name is employee?
And also find bottom 2nd lowest salary ?
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
State and explain about microsoft.net?
Explain .net mobile selectionlist control? : Microsoft dot net mobile
What are the types of memory management? : Dot net architecture
What is the difference between absolute expiration and sliding-time expiration?
What size is a .net object?
how can we achieve language interoperability through CLS? How MSIL works?
Explain difference between state server and sqlserver? : .NET Architecture
What is .net mobile utility controls. : Microsoft dot net mobile
What is the purpose of Accordian in jquery? Where it can be used?
How cache coherency is eliminated? : Dot net architecture
inprocess vs out process session state : Dot net architecture
What is .net viewstate?
What is cache coherency? : Dot net architecture
Explain different pipelining hazards? : Dot net architecture
What is a managed code is dim fs as filestreamobject is a managed code? : .NET Architecture