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
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..
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
What do you understand by the term 'aggregate cache'?
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..
Which studio is used to create reports?
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..
Write some methods to apply securities in framework manager model?
What is the use of report studio?
What is the difference between a cascading report and drill through report?
------------ Diff b/w MemberCaption and MemberDescription?
What are shortcuts? Where it can be used? What are the advantages?
What is the use of Cognos scenario?
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..
how u burst the reports? if u r bursted reports is not reached to destination how u identify???