Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7479 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
How do you set a varible in incremental aggregation
How will the document be delivered to me?
What is meant by LDAP users?
Why union transformation is an active transformation?
What is enterprise data warehousing?
Explain the different dimensions.
Whats the difference between informatica powercenter server, repositoryserver and repository?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is an aggregator transformation?
what are the deliverables?in your project?
What are the types of schemas we have in data warehouse and what are the difference between them?
Why do you use Mapping Parameter and mapping variable?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What are the types of lookup transformation?
What are mapplets? How is it different from a Reusable Transformation?
