I'd like to select from a single table with a simple set of data, but somehow transpose the type column into multiple columns using a simple select statement.

An example of the data I'm working with:

What I am hoping to achieve, using SQL only:

Any help will be greatly appreciated.

Best regards, Joel

CodePudding user response：

If 1 means SMS, 2 means Email, and 3 means Online, then the query can look like:

select
  date,
  sum(case when type = 1 then 1 else 0 end) as sms,
  sum(case when type = 2 then 1 else 0 end) as email,
  sum(case when type = 3 then 1 else 0 end) as online
from t
group by date