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
7853 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

What are the different transaction levels available in transaction control transformation?

1274

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

1080

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2071

What is workflow monitor?

1099

Difference between Target-based loading and constraint-based loading?

1042

What is Index Caches size?

1163

Which transformation is needed while using the Cobol sources as source definitions?

1219

lookup transformation with screenshots

4050

What are the different components of powercenter?

1113

what are factless facts? And in which scenario will you use such kinds of fact tables.

1855

what is $$$$?

2202

where to store informatica rejected data?

1139

What is sq transformation?

1230

What is joiner transformation in informatica?

1100

how many types of dimensions are available in informatica?

1180