Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to display to 10 max record from the employee
table?
- 7 Answers
- 14051 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
Can you define cognos powerplay?
What are all the different types of prompt in cognos?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
What you mean by drill across and what is the difference between drill through, drill across?
What do you understand by the term 'aggregate cache'?
what are slowly changing dimensions? Why we are used scd?
Can you define framework manager?
What do you understand by the term 'dynamic cube'?
Explain the different types of views used in cognos.
What is meant by alternate drill down with ex?
What are the advantages of using cognos sql?
What r the names of the reports that you prepared?
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
What is difference between data mart and data warehouse?
how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?
