sql排序怎么写？？？

[dnpao]

这条件语句目前是按照 A.posttime DESC 排序的

但我想让它，即 A.posttime DESC 又 A.id ASC 排序 应该怎么写？？？

SELECT B.*,A.*,C.title AS companyname,C.renzheng FROM sell_content A LEFT JOIN sell_comments B ON A.id=B.id LEFT JOIN sell_company C ON A.uid=C.uid  ORDER BY A.posttime DESC LIMIT 0,10

[wulinag]

SELECT B.*,A.*,C.title AS companyname,C.renzheng FROM sell_content A LEFT JOIN sell_comments B ON A.id=B.id LEFT JOIN sell_company C ON A.uid=C.uid ORDER BY A.posttime DESC,A.id ASC LIMIT 0,10

[rucypli]

ORDER BY A.posttime DESC, A.id ASC

[ACMAIN_CHM]

ORDER BY A.posttime DESC , A.id ASC

[huijiangpang]

引用 1 楼 wulinag 的回复:

SELECT B.*,A.*,C.title AS companyname,C.renzheng FROM sell_content A LEFT JOIN sell_comments B ON A.id=B.id LEFT JOIN sell_company C ON A.uid=C.uid ORDER BY A.posttime DESC,A.id ASC LIMIT 0,10

不是很明白，这样写出于什么样的考虑啊。 #2 & #3 的写法不可以么。。。

[Rotel-刘志东]

SELECT B.*,A.*,C.title AS companyname,C.renzheng FROM sell_content A LEFT JOIN sell_comments B ON A.id=B.id LEFT JOIN sell_company C ON A.uid=C.uid ORDER BY A.posttime DESC,A.ID ASC LIMIT 0,10;

[Rotel-刘志东]

引用 4 楼 huijianpang 的回复:

引用 1 楼 wulinag 的回复: SELECT B.*,A.*,C.title AS companyname,C.renzheng FROM sell_content A LEFT JOIN sell_comments B ON A.id=B.id LEFT JOIN sell_company C ON A.uid=C.uid ORDER BY A.posttime DESC,A.id ……

可以的 A.posttime DESC降序排列,再按照A.id ASC升序排序

[gfsdrgsdf]

A.posttime DESC 又 A.id ASC 排序 order by A.posttime desc,A.id asc 这个的意思是 先按 A.posttime降序之后， 结果再按照 A.id升序再拍一次 简单的说：posttime相等按id排序

[kk_lucky]

ORDER BY A.posttime DESC , A.id ASC