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

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

Answer Posted / kiran

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

Is This Answer Correct ?

7 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the session task and command task?

1062

tell me about your project functionality

2347

Which development components of informatica have the highest usage?

1047

To import the flat file definition into the designer where should the flat file be placed?

1061

what is mean by complex business rule ?

2162

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1865

What is the Process to creating lookup transformation in informatica

1046

what is the Default Source Option For Update Strategy Transformation?

1241

What is informatica powercenter repository?

1204

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6189

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1923

how many types of dimensions are available in informatica?

1103

Is stop and abort are same in informatica?

1002

Explain the etl program with few examples.

1054

What is meant by incremental aggregation?

1109