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 can we find nth max salary from A table

Answer Posted / a

select MAX(Salary) from Employee
WHERE Salary NOT IN (select MAX(Salary) from Employee )

Is This Answer Correct ?    0 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about mirror activator disk mirroring?

1016


What is the difference between plan and package in db2?

1120


What is a db2 schema?

1239


can we view the access paths created by dbrm ? how ? thx

7103


How do you stop a db2 database in linux?

1019


Discuss about db2 bind?

1103


Is db2 free?

1099


What is iseries database?

1054


What is the advantage in De-normalizing tables in DB2?

1182


What is rct?

1239


can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2248


How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1278


Is the primary key a clustered index?

1150


What is deadlock in db2?

1074


What are the various isolation levels possible?

1122