SELECT TS.*, T.Id, distinct(T.TopicsName) FROM `i_topics_statistics` AS TS INNER JOIN `i_topics_title` AS T ON TS.TopicsId = T.TopicsId INNER JOIN `i_topics` AS C ON C.Id=T.TopicsId WHERE 1 GROUP BY T.TopicsName ORDER BY TS.Discuss DESC
去除重复数据记录
SQL语句出错了,在什么地方?
去除重复数据记录
SQL语句出错了,在什么地方?
FROM `i_topics_statistics` AS TS
INNER JOIN `i_topics_title` AS T ON TS.TopicsId = T.TopicsId
INNER JOIN `i_topics` AS C ON C.Id=T.TopicsId
WHERE 1=1
GROUP BY T.TopicsName
ORDER BY TS.Discuss DESCdistinct要紧跟着select后面