write a query to display to 10 max record from the employee
table?
- 7 Answers
- 12086 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / srinu
select * from(select rownum r,emp.*from emp order by sal
desc) where r<=10;
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
what is the difference between native sql and cognos sql?
What DB View and Bus View?
2. What functional area you worked on.
-----------With out using DrillThrough how to do Reports?
What is main difference mapplets and mapping?
What are shortcuts? Where it can be used? What are the advantages?
what is hints in cognos and where we use it.
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
What do you mean by Drill down and Drill Up?
-----------------What is Determination Model?
What is the model filter?
How do we convert from Numeric to be Words?
What are the different types of important services used in cognos?
How can we create a dynamic column name in cognos?
What are the different types of reports present in cognos?
