在mysql上转置查询的结果是不可能的?我有这样的查询: (SELECT SUM(LIFT_ON) FROM tb_fin_repo b WHERE LPAD(MONTH(MONTH(g.OUT_DATE),2,0)) AS REPAIR
WHERE LPAD(MONTH( a.OUT_DATE), 2, 0) = 05
结果是
在我的表Product ( MySQL )中,我想计算一下在Fav中保存了多少Product_Id、购买或交付了多少Product_Id。然后,通过Fav、购买、在列中交付或逆行将结果组织为null或null,如下面所解释的那样。使用此查询:
SELECT COUNT(IF(Fav IS NOT NULL, ID, NULL)) AS "Fav_Not-null", COUNT(IF(Fav IS NULL, ID, NULL)NULL)) AS "Delivery_Not-null", COUNT(