Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Blog
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
-1
May
by Max123Master987, 3 months ago
Lalalalalalalalaal
by Max123Master987, 3 months ago
Please
log in
to post a comment.
mysql - having
media challenge response
bdUrbanFix
daily score
Yta
akshay dbms query
Srinivas
calculate averages for students and levels
Ordenar Valores de Columnas
Pivot Table test
May
by Max123Master987, 3 months agoLalalalalalalalaal
by Max123Master987, 3 months agoPlease log in to post a comment.