sql 根据数量进行排序

Select Top 10 A.p_id, B.p_name, SUM(A.p_number) as SumNumber, SUM(A.p_price) as SumPrice from OrderDetails A left join Product B ON A.p_id = B.p_id Group By A.p_id, B.p_name Order by SUM(A.p_number) DESC说明：查询结果中p_id是商品ID, p_name是商品名称，SumNumber是总数量，SumPrice是总售价记录根据总数量（SumNumber）来排序取前十条记录。另外，在联合查询中使用left join 查询时最有效率的查询方法

select top 10 t1.p_id , t1.p_name , sum( t2.p_number ) as 购买总数 from Product t1
inner join OrderDetails t2 on t1.p_id = t2.p_id
group by t1.p_id , t1.p_name
order by sum( t2.p_number ) desc