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 the use of virtual, sealed, override, and abstract.

996

question related to table havi colspan and row span

2270

What are different types that a variable can be defined and their scopes ?

1063

what is tracing? Where it used?

1111

Does .NET runtime offer Deterministic Destruction or not?

1032

How can I write my own .NET host?

1019

server.transfer limitation ?

2235

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

1083

What is cache coherency and how is it eliminated? : Dot net architecture

957

Difference between type constructor and instance constructor?

1139

What is a service class?

1013

Explain about appdomains?

1038

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

942

Can I create my own permission set?

1056

Explain about continuable exceptions?

981