Reputation: 28586
I am SQL beginner and I have the following question:
I have the following data (article sales by week)
COUNT WEEK ART
4 1 A
9 1 B
5 2 A
4 2 B
6 3 A
5 3 B
7 4 A
2 4 B
I would like to have the following output
ODD_WEEK EVEN_WEEK ART
10 12 A
14 6 B
in other words, I would like to group the elements by a criteria in a column (ODD_WEEK) and by an other criteria in another column (EVEN_WEEK)
Is it possible in T-SQL?
Upvotes: 0
Views: 69