「貝森朵芙巡更」:修訂間差異
跳至導覽
跳至搜尋
新頁面: <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'),PLA... |
無編輯摘要 |
||
| 第4行: | 第4行: | ||
WHERE DATE_FORMAT(DT,'%Y/%m')='2018/05' | WHERE DATE_FORMAT(DT,'%Y/%m')='2018/05' | ||
GROUP BY DATE_FORMAT(DT,'%Y/%m/%d'),PLACE,O | 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> | </SQL> | ||
於 2018年10月2日 (二) 16:57 的最新修訂
<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>