Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
MYSQL PIVOT
create temporary table temp(reqtypeid int, reqcode int); insert into temp(reqtypeid, reqcode) values (NULL, 0); insert into temp(reqtypeid, reqcode) values (NULL, 2); insert into temp(reqtypeid, reqcode) values ( 1 , 0); insert into temp(reqtypeid, reqcode) values (1 , 1); insert into temp(reqtypeid, reqcode) values (2 , NULL); insert into temp(reqtypeid, reqcode) values ( 2 , 0); insert into temp(reqtypeid, reqcode) values ( 2 , 1); insert into temp(reqtypeid, reqcode) values ( 3 , 1); insert into temp(reqtypeid, reqcode) values ( 4 , NULL); insert into temp(reqtypeid, reqcode) values ( 4 , 1); select * from temp; drop table temp; SELECT reqtypeid, SUM(CASE WHEN (reqcode='NULL') THEN 1 ELSE 0 END) AS reqcode_null, SUM(CASE WHEN (reqcode='1') THEN 1 ELSE 0 END) AS reqcode_1, SUM(CASE WHEN (reqcode='2') THEN 1 ELSE 0 END) AS reqcode_2, SUM(CASE WHEN (reqcode='0') THEN 1 ELSE 0 END) AS reqcode_0 FROM temp GROUP BY reqtypeid
run
|
edit
|
history
|
help
0
Sql
sunil
Práctica MySQL 1
proj
EquiposLiga
W
MySQL: calculate overlapping periods
Legitimate Resale
Srinivas
dbms queryn2