「貝森朵芙巡更」:修訂間差異

出自TSK WIKI
跳至導覽 跳至搜尋
Root​(留言 | 貢獻)
新頁面: <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...
 
Root​(留言 | 貢獻)
無編輯摘要
 
第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>