write a query to display to 10 max record from the employee
table?
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
how to connect datamarts
Can you define pivot?
dumps needed ASAP for - C2020-180 Cognos IBM Certification
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
How do you call a store procedure within a transformation?
how u will determine the performence tune will occur either in report or system
What is the difference between regular dimension and derminant?
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
What is meant by drill down?
what is stitch query in reportnet?
What are the methods by which it non-durable model could be changed into the durable model?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate How can we import Excel data in to FWM?Wt is mean by Ragged
dimensions?where can we observe the Regular dimensions &
measure dimensions? What are cognos connection initial page components? --------------Explain Table of contents?