摘要:
原始数据如下图:DateStatus2012-01-01win2012-01-01win2012-01-01win2012-01-01lose2012-01-01lose2012-01-02win2012-01-02win2012-01-02lose查询显示如下:Date win lose2012-01-01 3 22012-01-02 2 1View Code 1 WITH tbDate AS 2 ( 3 SELECT DATE FROM tbUsers GROUP BY Date 4 ), 5 tbWin AS 6 ( 7 SELE... 阅读全文