write sql query following table
quarter sales
q1 1000
q1 2000
q1 3000
q1 4000
q2 5000
q2 6000
q2 7000
q2 8000
q3 1000
q3 2000
q3 3000
q3 4000
q4 5000
q4 6000
q4 7000
q4 8000
i want the output format like
q1 q2 q3 q4
1000 5000 1000 5000
2000 6000 2000 6000
3000 7000 3000 7000
4000 8000 4000 8000
Answers were Sorted based on User's Feedback
Answer / letc
Using max function for q1,q2,q3,q4 in Aggregator transformation. Use sorter before aggregator
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / jj
without one more column its not possible i thing , it shoud
have prod or some thing
select prod,sum(q1),sum(q2),sum(q3),sum(q4) from (
select prod,(case when quarter='q1' then sal end) q1
,(case when quarter='q2' then sal end) q2
,(case when quarter='q3' then sal end) q3
,(case when quarter='q4' then sal end) q4 from za)
group by prod
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / ankit kansal
one solution can be like this
select max(q1) as q1,max(q2) as q2,max(q3) as q3,max(q4) as q4 from
(
select case when quarter = 'q1' then sales end q1
,case when quarter = 'q2' then sales end q2
,case when quarter = 'q3' then sales end q3
,case when quarter = 'q4' then sales end q4
,row_number() over ( partition by quarter order by 1 ) rnk
from sequel_test order by 5
)tb group by rnk order by 1,2,3,4
Is This Answer Correct ? | 1 Yes | 1 No |
Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?
what is the method of error handling when session is running?
How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
what is difference between COM & DCOM?
HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.
Two Default User groups created in the repository are ____ and ______
What is workflow? What are the components of the workflow manager?
 Informatica Checkpoints
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
what is meant by data driven.. in which scenario we use that..?
can we send mail when ever it get success or faulure to other mailid?(Not company mail id)