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
- 12923 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / ram
select * from
(
select e.*,dense_rank() over(order by sal desc) rank from emp e
)
where rank<=&rank
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What you mean by drill across and what is the difference between drill through, drill across?
1. Explain your project.
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
what is the role of cognos comsultant?what actually it means?pls reply
What is defined as data mining?
Can you define a query subject?
Which lifecycle we will use for reporting?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
Can you define bitmap index?
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 are the types of folder present in cognos?
Can you define dimension?
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
what are the names of the reports that you prepared?
