疑问。。大家帮忙看看

[aierduo]

SQL帮助里有一个例子 排序的
USE pubs
SELECT type, pub_id, AVG(price) AS 'avg', sum(ytd_sales) AS 'sum'
FROM titles
GROUP BY type, pub_id
ORDER BY type, pub_id

-----------
我修改了一下
USE pubs
SELECT type, pub_id, sum(price) AS 'pricesum', sum(ytd_sales) AS 'salesum'
FROM titles
GROUP BY type, pub_id
ORDER BY pricesum, salesum desc
-----------
但是得到的结果 和我想象的不一样的
请问如何修改才能让它 先安pricesum 降序排列再安salesum 降序排列

[paoluo]

USE pubs
SELECT type, pub_id, sum(price) AS 'pricesum', sum(ytd_sales) AS 'salesum'
FROM titles
GROUP BY type, pub_id
ORDER BY pricesum desc , salesum desc

[paoluo]

加上個desc即可

[aierduo]

晕
还有这么玩法的
OK

[freeliu]

每一个参与排序的字段，都可以指定排序方式，且每一个都可以不一样。