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

without table how to come first record only in oracle?

2301

difference between repository database and repository service?

1224

What are the modules in Power Center

1718

Where is metadata stored?

1192

What is a code page?

1219

How to update or delete the rows in a target, which do not have key fields?

1222

How to elaborate powercenter integration service?

1174

What are the types of presistent cache in look up tr.

2104

Explain direct and indirect flat file loading (source file type) - informatica

1359

Why do you use Mapping Parameter and mapping variable?

1808

Define mapping and session?

1089

Explain incremental aggregation in informatica

1185

Could you explain what is enterprise data warehouse?

1224

Describe the impact of several join conditions and join order in a joiner transformation?

1115

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1141