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
15633 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 the number or character entered through keyboard gets converted to equivalent ascii code & it get stored on ram in the binary form. What is the exact procedure on hardware that converts the ascii value to binary? : .NET Architecture

866

Which software is used for .net programming?

923

What's the difference between an application and a program?

1113

What is ILDASM ?

1102

How to improve the cache performance? : Dot net architecture

915

Explain Intermediate Language?

1049

How to develop mobile applications using microsoft mobile internet toolkit (mmit) or .net mobile? : Microsoft dot net mobile

927

Is dim fs as filestreamobject is a managed code? : Dot net architecture

966

Explain the number or character entered through keyboard gets converted to equivalent ascii code & it get stored on ram in the binary form. What is the exact procedure. : Dot net architecture

930

Can you explain atlasuiglitz library?

918

Can I create my own permission set?

1018

Explain write back and write through caches? : Dot net architecture

1014

How can we integrate atlas with web services?

938

Explain pipelining? : Dot net architecture

981

What is the purpose of Treeview control?

993