Question

mysql 多表 查询 之后 group by 分组 order by 无法按照日期排序

SELECT Z.* from (A.title,A.sortrank,A.pubdate FROM `acms_archives` as A left join `acms_arctype` as B ON A.typeid = B.id where B.topid=18 and A.arcrank=0 and A.sortrank = A.pubdate and A.pubdate > 0 group by A.mid )Z order by A.pubdate desc limit 0,7 结果总是 正序 怎么让他按时间倒序排列
刚才发错sql了 在发一次。
SELECT A.title,A.sortrank,A.pubdate FROM `acms_archives` as A left join `acms_arctype` as B ON A.typeid = B.id where B.topid=18 and A.arcrank=0 and A.sortrank = A.pubdate and A.pubdate > 0 group by A.mid order by A.pubdate desc limit 0,7

Answer 1

DESC 表示按倒序排序(即：从大到小排序)没错啊,错误的是你sql group by的问题哦
，在select后面除了聚合函数必须只有group by后面的字段,而你的...

Answer 2

把desc去掉

Answer 3

你这个Sql语句本身都有问题，按分组的话，你显示的字段都要放在分组里；
sql语句正确后，按时间降序排列是正确的