Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to display to 10 max record from the employee
table?
- 2 Answers
- 5545 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / lakshmi reddy
top 10 records
select * from emp where rownum<=10
Based on maximum salary(hithest top 10 salaries with details)
select * from (select emp.* from emp order by sal desc)
where rownum<=10
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?
5. Which type of report you build more, list, crosstab or chart and why?
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....
What is the difference between set functions and filter function in dimensional data?
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
How to join multiple db in catalog?
What is the difference between ‘macro’ and ‘prompt?
What is Additive function?
What is cognos powerhouse?
What junk dimension contains?
Why cognos decision stream is used?
explain how to create powerplay reports?
How to do Performence Tunning in Cognos Reports?
