Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to display the third record from the employee
table?
- 4 Answers
- 8324 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / krishna
To display the 3rd record of emp table we can write query as
select * from emp where rownum<4 minus select * from emp
where rownum<3;
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
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?
What is the difference between ‘macro’ and ‘prompt?
What is the use of Cognos scenario?
Explain about scorecarding?
How to generate cubes in cognos?
Define dimensions?
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
New coloums are added in database, then how you know in report level
What is the difference b/w macros and prompt?
What are the different uses of a repository manager?
actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....
Explain what is the main advantage of impromptu over cognos reportnet?
What are the roles defined by cognos platform?
Define query items?
Can you define confirmed dimension?
