first create a table emp4 using the above data then execute the below quer

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 / situ

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

Answer Posted / situ

first create a table emp4 using the above data then execute the below query to find that output
select case when grouping(name)=1 then 'Total'else name end as name,sum(sal) as sal from emp4 group by rollup(name);

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Differences between connected and unconnected lookup?

1201

Write the unconnected lookup syntax?

1067

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1073

How to improve the performance of a session using sorter transformation?

1132

What is informatica etl tool?

986

how tokens will generate?

2186

Explain informatica architecture - version 8 / 9

1072

Explain sessions. Explain how batches are used to combine executions?

1007

What is transformation?

1089

How to create the source and target database connections in server manager?

1071

Briefly describe lookup transformation?

1030

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1767

How do you load first and last records into target table?

1143

Can u generate reports in Informatica?

1060

Write the unconnected lookup syntax and how to return more than one column.

1097