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

Explain cache? : .NET Architecture

974

What re interop services?

993

8. Oop-Why and were we use Interfacse and Abstract class.

2130

How do I stop a thread?

935

Name some changes done since version 3.0?

944

Can you explain server controls in atlas?

956

Explain cache memory? : .NET Architecture

965

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

1042

what is diffrent beatween localprinter and networkprinter

1736

Explain the race around condition? : Dot net architecture

891

Define an interrupt? : Dot net architecture

955

Explain about httpruntime.cach.get(); method?

999

Explain difference between state server and sqlserver? : .NET Architecture

926

deference between display and visibility property of CSS

2262

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

889