select max(salary) as Salary from tbl_Employee where salary <= (select

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 / mohsin mukri

Answer Posted / mohsin mukri

select max(salary) as Salary from tbl_Employee
where salary <= (select max(salary) from tbl_employee)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Xmlserializer is throwing a generic "there was an error reflecting myclass" error. How do I find out what the problem is?

944

Explain how does .net mobile work? : Microsoft dot net mobile

847

Define cache coherency? : Dot net architecture

976

4. Wcf- what Asych and Sych call and how that works

1920

Explain cache? : Dot net architecture

970

Describe the advantages of writing a managed code application instead of unmanaged one. What is involved in certain piece of code being managed?

1005

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

926

Explain pipelining? : Dot net architecture

981

What does this do? Gacutil /l | find /i "corillian"

1018

.Net Frame work arch?

2026

What is the difference between an application and a program?

906

Use of Enable view state ? if turn off what happen ?

4455

What is .net mobile utility controls. : Microsoft dot net mobile

960

Can you explain scriptmanager control?

994

inprocess vs out process session state : Dot net architecture

929