求一条sql查询语句？
我现在有一个表：
order_ID: 订单编号
BookID： 图书编号 这两个是主键
BookSellprice ：图书单价
Bookamount： 图书数量
现在要取出相同图书既BookID相同的，图书数量总和最大的前10个BookID
这是我在做一本书上的例子，求销售排行，请各位帮忙想一想？？
[解决办法]
select top 10 sum(Bookamount) as qty,BookID from yourtablename group by BookID order by qty desc
[解决办法]
求数量排行榜：
select top 10 sum(Bookamount) as BookTotal ,BookID from 表名 group by BookID order by BookTotal desc
求销售价格排行榜
select top 10 BookID,sum(BookSellprice*Bookamount) as BookTotal from 表名 group by BookID order by BookTotal desc
