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

what is the method while we are using adapter and dataset ?

1872

What size is a .net object?

1042

What does the term "green architecture" mean? : .NET Architecture

973

where should I put this information then?

984

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

957

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

1053

Explain how cache is used? : Dot net architecture

1086

Define a managed code? : Dot net architecture

962

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

2232

how to create applications by using Visual Studio 2012?

970

Define cache coherency? : Dot net architecture

1001

What is code access security (cas)?

1035

Define a virtual memory? : Dot net architecture

921

How does .net remoting work?

1101

Why am I getting an invalidoperationexception when I serialize an arraylist?

904