SELECT * FROM employee WHERE Salary=(SELECT max(Salary) FROM employee WH

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 * FROM employee
WHERE Salary=(SELECT max(Salary)
FROM employee WHERE Marks< (SELECT max(Salary) FROM
employee));

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is WPF and WCF?

962

Explain .net mobile automatic paging? : Microsoft dot net mobile

869

Explain difference between machine config vs. Web config? : .NET Architecture

912

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

898

What is .net mobile input validation. : Microsoft dot net mobile

885

What are the options provived by vss to the user? how it will help us while delevoping application?

2158

How cache is used? : Dot net architecture

932

How do you handle this COM components developed in other programming languages in .NET?

1003

How cache coherency is eliminated? : Dot net architecture

861

What is MS chart control in visual studio?

1162

How do I know when my thread pool work item has completed?

868

What is a clickonce application?

874

What is the difference between .net mobile pages and ordinary .net web page? : Microsoft dot net mobile

890

What is the access level of the visibility type internal?

910

How to improve the cache performance? : .NET Architecture

910