Scenario is like this:
Name Sal
A 10;
B 20;
C 30;
Then Output should be
Name Sal
A 10;
B 20;
C 30;
Total 60;
Use SQL For this scenario
- 4 Answers
- 6535 Views
- TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / kiran
SQL> select ename,sal from emp union select 'total:',sum(sal) from emp;
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
write a query to retrieve the latest records from the table sorted by version(scd)
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is flashback table ? Advance thanks
Which are the different editions of informatica powercenter that are available?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
How to generate sequence numbers without using the sequence generator transformation?
How to start a workflow using pmcmd command?
How to create the source and target database connections in server manager?
If informatica has its scheduler why using third party scheduler?
How are indexes created after completing the load process?
What is the function of union transformation?
What is meant by target load plan?
differences between service based and product based?
what is mean by complex business rule ?
What are the designer tools for creating transformations?
