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 / asp

select * from table1 a where (n-1) = (select count(distinct
(sal)) from table1 b where b.sal>a.sal)

Is This Answer Correct ?    15 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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


What is db2 look?

1024


How to create db2 table in mainframe?

1154


What are the two types of logging in the db2 database? Explain them.

1074


What is copy pending and check pending in db2?

1004


How can the duplicate values be eliminated from db2 select?

1106


What is cascading rollback?

1214


Mention data types used in db2 ?

1158


What is buffer pool?

1106


How can you do the explain of a dynamic sql statement?

1069


How to create backup table in db2?

1091


How does db2 sample database connect?

1030


When reorg is used?

1129


What is the difference between oracle and db2?

1109


What language is db2 written in?

1049