求一条SQL语句

孤独冷雨发布于 2010-04-05 16:40， 838 次点击

现在有个订单表：

只有本站会员才能查看附件，请登录

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

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

6 回复

cnfarer2010-04-05 21:05

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

孤独冷雨2010-04-06 10:38

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

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

qxl85102010-04-08 19:31

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

qxl85102010-04-08 19:32

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

qxl85102010-04-08 19:35

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

Tailor2010-04-09 12:04

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