SELECT YEAR, SUM(DECODE(QUARTER,'FIRST',AMOUNT)) Q1

write sql query following table
amount year quarter
1000 2003 first
2000 2003 second
3000 2003 third
4000 2003 fourth
5000 2004 first
6000 2004 second
7000 2004 third
8000 2004 fourth

i want the output
year q1_amount q2_amount q3_amount q4_amount
2003 1000 2000 3000 4000
2004 5000 6000 7000 8000

Question Posted / chanakya123

1 Answers
4669 Views
HP, I also Faced
E-Mail Answers

Answer Posted / chanakya123

SELECT YEAR,
SUM(DECODE(QUARTER,'FIRST',AMOUNT)) Q1_AMOUNT ,
SUM(DECODE(QUARTER,'SECOND',AMOUNT)) Q2_AMOUNT,
SUM(DECODE(QUARTER,'THIRD',AMOUNT)) Q3_AMOUNT,
SUM(DECODE(QUARTER,'FOURTH',AMOUNT)) Q4_AMOUNT
FROM TABLE_NAME GROUP BY YEAR

Is This Answer Correct ?

9 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain direct and indirect flat file loading (source file type) - informatica

1359

Could you explain what is enterprise data warehouse?

1224

How we can create indexes after completing the loan process?

1251

Explain lookup transformation in informatica

1128

What are pre and post-session shell commands?

1387

What is a code page?

1219

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2108

What is a repository manager?

1148

How to create a non-reusable instance of reusable transformations?

1170

What is workflow? What are the components of the workflow manager?

1171

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1989

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7234

What are the differences between source qualifier and joiner transformation?

1137

What are ETL Tools?

1170

What are the components of the workflow manager?

1181