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 to findout the 100th maximum salary

Answer Posted / katasani rajesh reddy

select salary from(select salary from
order by salary)
where rownum<=100
minus
select salary from(select salary from
order by salary)
where rownum<=99

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to assign sql query results to pl sql variables?

1086


Difference between table function and pipelined function?

1029


what is difference between delete and truncate commands? : Sql dba

1138


what is user defined functions? : Sql dba

1038


Does google use sql?

970


What are dml commands?

1026


How to rename a table?

1031


What is the difference between local and global temporary table?

1053


What packages(if any) has oracle provided for use by developers?

5813


What are the steps for performance tuning.

1342


What is difference between cursor and trigger?

1084


How do you bind variables in pl sql?

1104


What are different functions in sql?

951


What is pl sql script?

1036


How can we optimize a sql query?

1054