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

can we override a native sql query within informatica? How do we do it?

743

What will be the approach?

667

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1649

What is main use of mapplet?

760

what is diff b/t sorter t/r and agg have the option sorter property...

1852

Separate from a database, an information bazaar, and an information stockroom?

699

Define mapplet?

706

What is meant by target load plan?

644

Partition, what happens if the specified key range is shorter and longer

2114

What does cheating measurement mean?

682

Write the prerequisite tasks to achieve the session partition?

737

What could be the possible resons of locks by user?

746

What is the use of an aggregator cache file?

777

What does role playing dimension mean?

714

What happens when a session fails and you click on recover?

743