How to group by data from rows to columns

Question

I have a table as below (Time sheet)..I want to flatten the table to Flattened_TimeSheet..Can I use group by here? If not could someone help me with the query.

You can go with two approaches either using `case` or `pivot`. [Here is pivot](https://stackoverflow.com/questions/11348562/pivoting-with-sum-function-in-tsql) — Mahesh, Sep 28 '18 at 01:49

score 1 · Accepted Answer · answered Sep 28 '18 at 01:25

1

try this:

select ID,
sum(case when type='a' then hour else 0 end) as A,
sum(case when type='b' then hour else 0 end) as B,
sum(case when type='c' then hour else 0 end) as C
from TimeSheet
where type in ('a', 'b', 'c')
group by ID

answered Sep 28 '18 at 01:25

Esperento57

16,521
3
39
45

Is `where type in ('a', 'b', 'c')` condition required? – Dishant Sep 28 '18 at 02:04
Not really, but in this case for this search, its more fast ;) – Esperento57 Sep 28 '18 at 05:48

How to group by data from rows to columns

1 Answers1