write sql query following source table jan feb mar apr 100 200 300

write sql query following source table

jan feb mar apr
100 200 300 400
500 600 700 800
900 100 200 300
i want the output format like

month total
jan 1500
feb 900
mar 1200
apr 1500

Question Posted / dinesh

3 Answers
7287 Views
Accenture, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

write sql query following source table jan feb mar apr 100 200 300 400 500 600 700..

Answer / chanakya123

Hi, Using UNION ALL ,You can achieve it, here is Your Query

SELECT 'JAN' AS MONTH, SUM(JAN) AS TOTAL FROM SRC_MONTHS
UNION ALL
SELECT 'FEB' AS MONTH, SUM(FEB) AS TOTAL FROM SRC_MONTHS
UNION ALL
SELECT 'MAR' AS MONTH, SUM(MAR) AS TOTAL FROM SRC_MONTHS
UNION ALL
SELECT 'APR' AS MONTH, SUM(APR) AS TOTAL FROM SRC_MONTHS

Thanks
Kalyan Sankuthula

Is This Answer Correct ?

23 Yes

0 No

write sql query following source table jan feb mar apr 100 200 300 400 500 600 700..

Answer / triveni

i have one doubt.how to convert source to columns using sourcequalifier. how many columns target we have take.
how to connect source to target
source has 4 columns
target has 2 columns

Is This Answer Correct ?

0 Yes

0 No

write sql query following source table jan feb mar apr 100 200 300 400 500 600 700..

Answer / amitabha mandal

use "Normalizer"

Is This Answer Correct ?

0 Yes

1 No

Post New Answer