select max(salary) as Salary from tbl_Employee where salary

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

11 Answers
16069 Views
GeoTechnology, Wipro, I also Faced
E-Mail Answers

Answer Posted / mohsin mukri

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

sory above post ans is wrong bcoz i forgot to remove = sign

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Differences between VS 2005, 2008 and 2010 ?

1064

What is application frame host?

1132

Define cache? : Dot net architecture

1006

What is Video Streaming in .net??

1030

What are .net mobile controls features? : Microsoft dot net mobile

999

Explain some of the disadvantages due to microsoft.net?

1032

How do I prevent concurrent access to my data?

1081

Explain about clr?

1107

how to make and display a form without title bar?

1994

Explain the five stages in a dlx pipeline? : Dot net architecture

975

What is a service class?

1060

I want to create a project like google maps how can we do that with atlas?

998

Is .net easier than java?

980

So what exactly is the configuration file for then?

1010

What is boxing and unboxing? Does it occure automaatically or you need to write code to box and unbox?

1021