mysql 中的多重排序order by
主要排序的放前面以此类推,最多可以放16个
SELECT a.* , (a.GROUP_NUM+0) as groupon, (a.UNIT_ID+0) as uniton FROM t_word_group a WHERE BOOK_ID=’1′ order by uniton, groupon
mysql 中的多重排序order by
主要排序的放前面以此类推,最多可以放16个
[ccn lang="sql" tab_size="4" theme="blackboard" width="800" ]
SELECT a.* , (a.GROUP_NUM+0) as groupon, (a.UNIT_ID+0) as uniton FROM t_word_group a WHERE BOOK_ID='1' order by uniton, groupon
[/ccn]