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...

write a query to display to 10 max record from the employee
table?

Answer Posted / harish

based on salary top 10 records for emp table

select * from ( select * from emp order by sal desc)where rownum<=10;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Give me any example of semi and non additive measures?

963


please please give me some banking calculations in framework manager.

2081


Can you explain cognos planning?

1088


Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)

2440


hi friends pls forward impropmtu interview question

2125


What are the two types of framework manager?

1323


my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...

4217


-----------Diff b/w OLAP and RDBMS?

2043


What do you understand by the term 'aggregate cache'?

975


difference between impromptu and cognos8

2426


What are the types of studio present in Cognos?

1034


what is the difference between list report and crosstab report?

1179


what do u mean by bridge group? where we r using this one?

1982


What are the advantages of cognos?

974


How to deploy from one server to another server?

2488