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 / 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
Name some changes done since version 3.0?
Explain what does the term "green architecture" mean? : .NET Architecture
Explain the five stages in a dlx pipeline? : .NET Architecture
What's the difference between an application and a program?
Explain cache memory? : Dot net architecture
define cache memory? : Dot net architecture
Explain difference between machine config vs. Web config? : .NET Architecture
Waht is Dot net Arcitecture
What is the purpose of Treeview control?
Define a managed code? : Dot net architecture
Explain the race around condition? : Dot net architecture
Explain dma? : .NET Architecture
How do I write to the application configuration file at runtime?
What is the difference between l1 and l2 cache? : Dot net architecture
Explain COM with example?