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...

can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com

Answer Posted / harikumar

select max(salary) as secondMax from employee where id <>
(select max(salary) from employee)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to populate a table in sql server?

995


Explain about nested stored procedure?

1084


What is normalization process?

1241


Which are ddl commands?

1119


What does it mean to be in union?

983


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5978


What do you understand by a stored procedure?

1154


Explain throw statement in sql server 2008?

1054


What is an execution plan?

1240


How you can move data or databases between servers and databases in sql server?

1101


What is a benefit of using an after insert trigger over using a before insert trigger?

1034


What is the use of nvl work?

1046


Why I am getting this error when dropping a database in ms sql server?

1120


What is the status of services on passive node for failover cluster in sql server? : sql server database administration

1354


What is service broker? : sql server database administration

1032