现在有个订单表：


现在要统计出来销售的最好的七个产品。然后把销售的数量统计出来！
产品名称：p_name,订购数量：p_num

1、骑士天下    6
2、豹行天下    5
3、四喜娃娃    3

select top 7 p_name,sum(p_num) p_num from dingdan group by p_name order by p_num desc

Microsoft JET Database Engine (0x80040E14)
语法错误 (操作符丢失) 在查询表达式 'sum(p_num) p_num' 中。

有点不对。不过还是谢谢！

select top 3 p_name,sum(p_num)as [sum] from p_qin   group by p_name

写错了，写成我自己的数据库了，呵呵，正确的应该是：select top 7 p_name,sum(p_num)as [sum] from dingdan  group by p_name

select top 7 p_name,sum(p_num)as [sum] from dingdan  group by p_name order by [sum] desc

select top 7 p_name,sum(p_num)as P_sum from dingdan  group by p_name order by P_sum desc