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

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1246


How can you count the number of rows from a table tab?

1135


Who uses db2?

1112


List out the three types of page locks that can be held.

1193


Is ibm db2 open source?

1130


Define db2.

1171


What are packages in db2?

1075


Why do we use cursor?

1162


Define predicate?

1203


What is cobol db2?

1046


What is coalesce in db2?

1185


How is the value function used?

1208


When reorg is used?

1182


What is package in db2 mainframe?

1036


What is bind in db2?

1096