Member Avatar for Dumb Fish

Hi, everyone...
I have a question about sql ..

Question:

Customer | jan-april | may - august| september - december

A |quantity | |

B | | |

C | | |


How to use the SELECT command to retrieve data and the output is show like above.
please give me some examples.

Edited by Dumb Fish because: n/a
  • 5 Contributors
  • 6 Replies
  • 145 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Netcode
Member Avatar for debasisdas

What is the table structure ?

What have you tried so far ?

Member Avatar for Dumb Fish

You got any similar example can show me....?

Member Avatar for urtrivedi

change your columns names accordingly

select customer, sum(case when month(datecolname) in (1,2,3) then quantity else 0 end) jan_mar
sum(case when month(datecolname) in (4,5,6) then quantity else 0 end) apr_jun,
sum(case when month(datecolname) in (7,8,9) then quantity else 0 end) jul_sep,
sum(case when month(datecolname) in (10,11,12) then quantity else 0 end) oct_dec
from tablename
where  month(getdate())=2011
group by customer
Edited by urtrivedi because: n/a
Member Avatar for adam_k

urtrivedi's script should work, provided that the where is :

where year(datecolname) = '2011'

or something similar.

Member Avatar for Dumb Fish

YA ...i know that one....thx..the problem had been solved....

Member Avatar for Netcode

Great. You learn best when you try things out yourself.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.