Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

how to find the 2nd higgest salary in the column for example
take table name is employee?
And also find bottom 2nd lowest salary ?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain dotnet framework ?

1110


Explain about continuable exceptions?

1032


Tell me .net mobile emulators? : Microsoft dot net mobile

1009


How to improve the cache performance? : Dot net architecture

975


Differences between VS 2005, 2008 and 2010 ?

1064


How to prevent my .NET DLL to be decompiled?

1095


What is private constructor? And it's use?

1174


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

975


Can I create my own metadata attributes?

1107


How do we do authentications using atlas?

1018


What is the use of CLR in .NET?

1086


What is .net mobile images control. : Microsoft dot net mobile

969


What are relation objects in dataset?

1043


What is Com Callable wrapper?when it will created?

992


what are login controls?

1933