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

What is the use of triggers?

1082


Explain commit, rollback and savepoint.

1052


How do I run a pl sql procedure in sql developer?

1019


Explain the significance of the & and && operators in pl sql.

1046


How many types of tables are there?

994


What is the difference between join and natural join?

978


How many primary keys can a table have?

1052


What is auto increment?

1044


Mention what does the hierarchical profiler does?

1134


How can you get sql*loader to commit only at the end of the load file? : aql loader

1059


Can we create table in function?

1017


What is thread join () in threading?

1057


What is nvarchar max in sql?

1072


What is data abstraction in sql?

1064


Are dml statements autocommit?

1092