貝森朵芙巡更

出自TSK WIKI
跳至導覽 跳至搜尋

<SQL> SELECT DATE_FORMAT(DT,'%Y/%m/%d')DAY,PLACE,O,COUNT(PLACE) TIME FROM GOGO JOIN building ON PLACE=B WHERE DATE_FORMAT(DT,'%Y/%m')='2018/05' GROUP BY DATE_FORMAT(DT,'%Y/%m/%d'),PLACE,O </SQL>

2版

<SQL> SELECT DATE_FORMAT(DT,'%Y/%m/%d')DAY,B,O,COUNT(PLACE) TIME FROM GOGO JOIN building ON PLACE=A WHERE DATE_FORMAT(DT,'%Y/%m')='2018/09' GROUP BY DATE_FORMAT(DT,'%Y/%m/%d'),O </SQL>