Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to display to 10 max record from the employee
table?
- 8 Answers
- 13163 Views
- HCL, I also Faced
- E-Mail Answers
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 this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com
can we insert all types of charts in a list report? what r the realtime prompts?
What is meant by junk dimension?
what is log in cognos?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com
What is Bitmap Index?
is there any difference between operational database and data base?if yes what r they?
Can you define cognos decision stream?
What is the complex report you faced in real time?
1. Explain your project.
What is defined as Cognos Impromptu?
What is called Cognos powerplay?
-----------With out using DrillThrough how to do Reports?
