if am not wrong we can also do the same thing by using aggreate function li

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 / pankaj kumar

11 Answers
16056 Views
GeoTechnology, Wipro, I also Faced
E-Mail Answers

Answer Posted / pankaj kumar

if am not wrong we can also do the same thing by using aggreate function like Min or Max..

Like if i want to know 4th Highest Salary then i can

SELECT MIN(Sal) FROM TableName
WHERE Sal IN
(SELECT TOP 4 Sal FROM TableName ORDER BY Sal DESC)

Regards
Pankaj Kumar
pankaj.arrah@gmail.com

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain about the base class library provided by microsoft.net?

1144

What are the new features of .net 2.0?

1015

HttpHendler and HttpModules

2211

Whate are resource files? How are they used in .net?

966

Explain about continuable exceptions?

1028

What is .net viewstate?

979

Explain the race around condition? How can it be overcome? : Dot net architecture

1012

What is a managed code is dim fs as filestreamobject is a managed code? : .NET Architecture

1176

What is the purpose of Treeview control?

1051

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

1914

What is textbox control of .net mobile? : Microsoft dot net mobile

1108

What are the different pipelining hazards and how are they eliminated? : Dot net architecture

1088

Explain the process of gc?

1030

What is a managed code? : Dot net architecture

1019

What is WPF and WCF?

1047