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

select rownum, salary from (select salary from employees order by salary desc)
where romnum<=100

Is This Answer Correct ?    0 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are local and global Indexes and where they are useful.

1494


How do you go back in sql?

1029


What are the steps for performance tuning.

1395


How can we avoid duplicating records in a query?

1031


How does an execution block start and end in pl sql?

999


Is sql better than access?

1069


- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1893


Can we join more than 2 tables in sql?

1093


How many clustered indexes can you have?

1037


What are the set operators in sql?

1136


Are subqueries faster than joins?

1076


What is the use of primary key?

1049


What are string functions in sql?

1305


What is the difference between the conventional and direct path loads? : aql loader

1473


How do I add a database to sql?

1185