select name,salary from emp union select "total",sum(sal) from

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

Question Posted / niru

Answer Posted / niru

select name,salary from emp
union
select "total",sum(sal) from emp

Is This Answer Correct ?

11 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is union transformation?

570

What does update strategy mean, and what are the different option of it?

586

What is fact table? Explain the different kinds of facts.

610

Can we create a Integration service without a Repository service and vice versa?

723

What do you understand by SOA of Informatica?

583

difference between repository database and repository service?

618

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1576

Write the program through which the records can be updated?

512

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

621

What are batches?

617

Explian the Process of deployment groups in informatica

655

How to do the error handling of if ur source is flatfiles?

1508

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1513

Why do we need informatica?

554

Differentiate between source qualifier and filter transformation?

998