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

deference between display and visibility property of CSS

2279

Explain about microsoft visual studio?

974

how we can fire event in databound column in datagrid without using button?

1033

Define a virtual memory? : Dot net architecture

915

Explain what does the term "green architecture" mean? : Dot net architecture

959

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

2219

Explain the race around condition? How can it be overcome? : Dot net architecture

960

State and explain about microsoft.net?

949

what are the fundamental and common properties of .net controls?

2122

difference between data reader and dataset

2236

Define the mesi? : Dot net architecture

938

What are end points, contract, address and bindings?

931

Explain the five stages in a dlx pipeline? : .NET Architecture

923

What is a managed code? : Dot net architecture

971

What's new in the .net 2.0 class library?

927