mysql distinct,order by,group by冲突
SELECT `question_id`,from_unixtime(MAX(`created`)) FROM `b_answer` WHERE `pid`=0 GROUP by `question_id` ORDER BY MAX(`created`) DESC解决办法:使用内部函数先排序再去重原因: mysql distinct和order by 一起用时,order by的字段必
转载
2018-03-13 17:05:02 ·
787 阅读 ·
0 评论