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

what is a corelated subquerry?

1104


Why cursor is used in db2?

1019


What db2 400?

1143


What is a trigger in the db2 database?

1050


What are catalog tables in db2?

1030


i want to maintain uniqueness on pdf without make lf??????????

2142


What is lock escalation in db2?

1003


What is meant by explain?

1111


Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1393


How do I delete a table in database?

1004


What is package in cobol db2?

1104


Explain in brief how does db2 determine what lock-size to use?

1018


What is the function of logging in the db2 database?

1102


Mention the different locking levels that are available in db2.

1116


Which component is responsible for processing sql statements and selecting access paths?

1110