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

select *from emp where sal in(select max(sal) from emp where level<=10 connect by prior sal>sal group by level);


This query show the top 10 records based on the salary

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..

2159


hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2325


It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?

2358


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

920


hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1845


Which studio is used to create reports?

1059


i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2658


Write some methods to apply securities in framework manager model?

1045


What is the use of report studio?

975


What is the difference between a cascading report and drill through report?

1029


------------ Diff b/w MemberCaption and MemberDescription?

2270


What are shortcuts? Where it can be used? What are the advantages?

989


What is the use of Cognos scenario?

1140


how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..

2064


how u burst the reports? if u r bursted reports is not reached to destination how u identify???

11606