select *
from  news order by isTop,orderNum desc; +----+--------------+--------+------------+---------------------+----------+---------------------+--------+-------+----------+
| id | newsTitle    | typeId | newsCnt    | newsPic             | newsFrom | newsReleaseTime     | re | isTop | orderNum |
+----+--------------+--------+------------+---------------------+----------+---------------------+--------+-------+----------+
| 28 | 吊死扶伤     | 13     | 范德萨  |                     | 新闻来源 | 2008-11-07 09:37:14 |        |     0 |        2 |
| 24 | 地方法       | 14     | 饭店范德萨|                     | 新闻来源 | 2008-11-07 09:36:48 |        |     0 |        1 |
| 25 | 份额为恶完全 | 13     | 反而大放大|                     | 新闻来源| 2008-11-07 09:36:54 |        |     0 |        1 |
| 26 | 去           | 14     | 额外     |                     | 新闻来源 | 2008-11-07 09:37:01 |        |     0 |        1 |
| 27 | 范德萨范德萨 | 15     | 啊啊     |                     | 新闻来源 | 2008-11-07 09:37:08 |        |     0 |        1 |
| 29 | 发大水       | 14     | 发大水  |                     | 新闻来源 | 2008-11-07 09:37:21 |        |     0 |        1 |
| 30 | 放大         | 14     | 附答案  | 200811071052400.jpg | 新闻来源 | 2008-11-07 10:52:40 |        |     0 |        1 |
| 31 | dfs          | 14     | fa         |                     | 新闻来源 | 2008-11-07 10:55:02 |        |     0 |        1 |
| 32 | a            | 14     | a          |                     | 新闻来源 | 2008-11-07 10:55:08 |        |     0 |        1 |
| 23 | 新闻标题1    | 14     | 新闻内容|                     | 新闻来源 | 2008-11-07 10:58:08 |        |     1 |        1 |
我想先按 istop降序排列,再按ordrNum降序排列 这个顺序,为什么我这个语句不对?达人们帮一下,小弟刚学MYSQL