how to find the 2nd higgest salary in the column for example
take table name is employee?
And also find bottom 2nd lowest salary ?
- 11 Answers
- 13287 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
Explain a .net mobile example with details? : Microsoft dot net mobile
What is the cli? Is it the same as the clr?
What are relation objects in dataset?
How is the using() pattern useful? What is idisposable?
how to set the startup position of the form?
Explain write back and write through caches? : Dot net architecture
State the different levels of exceptional safety?
What is the mesi? : .NET Architecture
data types used in validation control
Explain what does the term "green architecture" mean? : Dot net architecture
What are .net mobile controls features? : Microsoft dot net mobile
Explain difference between state server and sqlserver? : .NET Architecture
Explain hard disk and what is its purpose? : Dot net architecture
What is .net mobile input validation. : Microsoft dot net mobile
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
