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 降序排列
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 降序排列
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