SQL> select ename,sal from emp union select 'total:',sum(sal)

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

Answer Posted / kiran

SQL> select ename,sal from emp union select 'total:',sum(sal) from emp;

Is This Answer Correct ?

7 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1116

Quickly characterize reusable change?

1180

In informatics server which files are created during the session rums?

1163

How to partition the Session?

1149

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1301

What's the layout of parameter file (what does a parameter file contain?)?

2432

Can anyone tell me the new features in Informatica 9 Version?

2203

how to load rows into fact table in data warehouse

1227

Why is sorter an active transformation?

1193

Write the different tools in the workflow manager?

1112

Sequence generator, when you move from develoment to production how will you reset

2121

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1915

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1160

What is different between the data warehouse and data mart?

1110

What do you understand by SOA of Informatica?

1041