write a query to display to 10 max record from the employee
table?
- 7 Answers
- 12524 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / m m naidu
To display first 10 records we can write the query as
select * from(select * from emp order by ename desc) where
ronum<=10;
| Is This Answer Correct ? | 7 Yes | 6 No |
Post New Answer View All Answers
Write some methods to apply securities in framework manager model?
write a query to display the departments with no employee?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
What is the difference between set functions and filter function in dimensional data?
how to connect datamarts
What is an olap designer?
How do you improve the performance of the Cognos Analytics report
Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!
How Metrics Studio is better than Report Studio?
Mention the difference between ‘macros’ and ‘prompt’?
how u will determine the performence tune will occur either in report or system
in u r data u having duplicates how to fetch the latest data in our report?
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?
tell me two or three issues from client side and how to solve those issues?
What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?
