如果排序正确,行应该返回如下:
Dec 3, 2010 - 10
Dec 3, 2010 - 10
Dec 3, 2010 - 8
Dec 3, 2010 - 7
Dec 3, 2010 - 3
Dec 3, 2010 - 1
Dec 2, 2010 - 10
Dec 2, 2010 - 9
Dec 2, 2010 - 3
Dec 1, 2010 - 8
Dec 1, 2010 - 5
Dec 1, 2010 - 5
Dec 1, 2010 - 4
有什么高效的解决方法吗?
发布于 2018-07-30 08:26:45
SELECT * FROM yourtable
ORDER BY `DATE` DESC, `IMPORTANCE` DESC
发布于 2018-07-30 10:06:05
这样试试:
SELECT * FROM table ORDER BY `date` DESC, `importance` DESC
https://stackoverflow.com/questions/-100001708
复制相似问题