Select case when GROUPING(e.Name)= 1 then'Total'else e.Name end

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

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

Answer Posted / pooja

Select case when GROUPING(e.Name)= 1
then'Total'else e.Name end as Name,
sum(e.Salary)as Salary from Emp e
group by e.Name with rollup

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

draw informatica architecture 8.6 ?

3877

Explain the types of lookup transformation?

1047

How to use procedural logic inside infromatica?

1249

What are the different lookup cache(s)?

1122

Why do we need informatica?

1002

What is rank index in rank transformation?

1082

What are the tasks that can be performed using sq?

1096

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2051

Explain the types of transformations?

1073

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

1983

What are some examples of informatica etl programs?

947

Is it possible to revert a global repository to local one and why?

1086

Explain the different lookup methods used in informatica?

1048

What are Dimensional table?

1064

what is $$$$?

2163