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

4 Answers
7632 Views
TCS, Wipro, I also Faced
E-Mail Answers

Answer Posted / niru

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

Is This Answer Correct ?

11 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the code page compatibility?

1050

What is a rank transform?

1072

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1055

What is a passive transformation?

1080

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2285

 Informatica Checkpoints

3309

define galaxy repository in informatica

2205

In development project what is the process to follow for an etl developer from day1

1700

Enlist some properties of sessions.

1055

What are the different versions of informatica?

1246

How can we use mapping variables in informatica? Where do we use them?

1167

What do you understand by term role-playing dimension?

1029

Why do you use Mapping Parameter and mapping variable?

1742

What are the settings that you use to configure the joiner transformation?

1038

tell me about your project functionality

2330