write a query to follwoing table
amount year quarter
254556 2003 first
546332 2003 second
129034 2003 third
490223 2003 fourth
165768 2004 first
265443 2004 second
510412 2004 third
435690 2004 fourth
i want the output
year q1_amount q2_amount q3_amount q4_amount
2003 254556 546332 129034 490223
2004 165768 265443 510412 435690
- 2 Answers
- 4519 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ankit kansal
The above answer is perfectly fine, however you can achieve the same using case
Select YEAR,SUM(q1_amt)q1_amt,SUM(q2_amt)q2_amt,SUM(q3_amt)
q3_amt,SUM(q4_amt)q4_amt from (
select YEAR,
CASE QUARTER WHEN 'first' THEN amount ELSE 0 END as q1_amt,
CASE QUARTER WHEN 'second' THEN amount ELSE 0 END as q2_amt,
CASE QUARTER WHEN 'third' THEN amount ELSE 0 END as q3_amt,
CASE QUARTER WHEN 'fourth' THEN amount ELSE 0 END as q4_amt
from t_name) temp group by YEAR;
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is event and what are the tasks related to it?
What is a stored procedure transformation?
Where do we use mapping variables in informatica?
What is the use of source qualifier?
define galaxy repository in informatica
What is standalone command task?
Explain the scenario which compels informatica server to reject files?
How to update or delete the rows in a target, which do not have key fields?
What are the guidelines to be followed while using union transformation?
Is it possible to use a client with different version than that of its Informatica server?
How do we call shell scripts from informatica?
What do think which one is the better joiner or look up?
How to open an older version of an object in the workspace?
How many number of sessions can one group in batches?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
