Select top 1 salary from tbl_registration where salary in (SELECT TOP 2

how to find the 2nd higgest salary in the column for example
take table name is employee?
And also find bottom 2nd lowest salary ?

Question Posted / arrry.net

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

Please Help Members By Posting Answers For Below Questions

what is the method while we are using adapter and dataset ?

1914

What are relation objects in dataset?

1041

What are bindings?

1050

IS IT Possible to inherit the AJAX page from child class which(child) is inherit from page class.Because i should apply some security in child class

2055

What is code access security (cas)?

1079

Explain the types of memory management? : .NET Architecture

988

Tell me .net mobile emulators? : Microsoft dot net mobile

1007

How can I create a application?

986

how to change row background color in gridview

1027

What is the numeric attribute of the textbox control in .net mobile? : Microsoft dot net mobile

1009

What are the important principles of soa (service oriented architecture)?

987

What does this do? Gacutil /l | find /i "corillian"

1074

How do we do authentications using atlas?

1016

What re interop services?

1055

Define a managed code? : Dot net architecture

1000