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
- 13162 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / madhoo
select * from emp a
where (select count(distinct sal) from emp b where
a.sal<b.sal)=&n order by sal desc
/
this is the exact query........when there are duplicate
salaries are there also........
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
What is set to be Cognos configuration?
how can you get the errors in job? when loops are araised we get error?
what is the role of cognos comsultant?what actually it means?pls reply
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
How to Reset Pagenumbers in one report.
HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks
What is zero-foot print?
What you mean by drill across and what is the difference between drill through, drill across?
what is hints in cognos and where we use it.
How do we convert from Numeric to be Words?
------------ Diff b/w MemberCaption and MemberDescription?
What are the types of security?
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
New coloums are added in database, then how you know in report level
What is the use of powerhouse?
