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

What do think which one is the better joiner or look up?

1143

What is the function of union transformation?

1062

How many ways are there to create ports?

1234

How can you differentiate between powercenter and power map?

1017

Explain the informatica workflow?

998

Performance tuning( what you did in performance tuning)

1907

Explain how many types of dimensions are available in informatica?

1004

What is the Rank index port in Rank transformation?

1011

what is Active lock explain

2723

Explain what are the different versions of informatica?

1030

what is informatica metadata?

974

How to handle decimal places while importing a flatfile into informatica?

1127

What is the benefit of session partitioning?

1039

What are the different clients of powercenter?

1006

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7071