Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to display the third record from the employee
table?
- 6 Answers
- 9953 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / ammu
select * from emp e where 4=(select count(sal) from emp
where e.sal>sal)
Because it follows n-1 rule..
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
how to create cubes in transformer ?
I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series
What are the message flows?
what do u mean by bridge group? where we r using this one?
what is catalog and types of catalogs in cagnos and which is better?
What are the main services provided by application tier?
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
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.
Can you define report item?
Can you define fan trap?
What are the steps to import the two data sources in framework manager?
------------ Diff b/w MemberCaption and MemberDescription?
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
what are slowly changing dimensions? Why we are used scd?
