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
7478 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 various types of transformation?

1094

What is meant by LDAP users?

1112

What are the measure objects?

1119

What are the types of lookup transformation?

1023

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1267

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

1013

How can we handle two sessions in informatica?

982

Explain joiner transformation in informatica

1074

What is the procedure for creating independent data marts from informatica 7.1?

1000

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

2129

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1894

Define update strategy?

1112

Which development components of informatica have the highest usage?

984

Explain the different kinds of facts.

933

Under what condition selecting sorted input in aggregator may fail the session?

1057