teratail header banner
teratail header banner
質問するログイン新規登録

回答編集履歴

1

ORDER BY修正

2017/06/21 06:12

投稿

SVC34
SVC34

スコア1149

answer CHANGED
@@ -8,6 +8,6 @@
8
8
  AND T2.`logDate` BETWEEN :startDate AND :endDate
9
9
  WHERE T1.`index` = 'yes'
10
10
  GROUP BY T2.`contentsCode`, T1.`title`
11
- ORDER BY T2.`totalAccess` DESC
11
+ ORDER BY `totalAccess` DESC
12
12
 
13
13
  ```