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 / parul verma

select min(salary) from (select distinct salary from emp
where salary is not null order by salary desc) where rownum
<=100;

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is exit statement?

1060


Can unique keys be null?

949


How much does sql cost?

1067


Which constraints we can use while creating database in sql?

1120


List and explain the different types of join clauses supported in ansi-standard sql?

1400


What is asqueryable?

1035


What is difference between primary and secondary key?

1073


Is it possible for a table to have more than one foreign key?

1080


What are the two types of exceptions.

1218


What are inner and outer joins examples of both?

1009


What is a trigger word?

1077


What is execution plan in sql?

1092


What is the purpose of the partition table?

1089


What has stored procedures in sql and how we can use it?

1126


What are the indexing methods?

1098