原表数据
如何实现
表
如何查询只输出销量最高的前类物品
select *from Sell
select top 2 * from(select SUM(S_num)as S_num,C_name from Sell
group by C_name
order by S_num desc)
用这个语句查询直接报错
------解决思路----------------------
select TOP 2 SUM(S_num)as S_num,C_name
from Sell
group by C_name
order by S_num desc
------解决思路----------------------
SELECT TOP 2 C_name,SUM(S_num)S_num
FROM Sell
GROUP BY C_name
ORDER BY SUM(S_num)DESC
这个意思?
------解决思路----------------------
可以这样
SELECT TOP 2 C_name,SUM(S_num)S_num
FROM Sell
WHERE C_name NOT IN (
SELECT TOP 4 C_name
FROM Sell
GROUP BY C_name
ORDER BY SUM(S_num)DESC
)
GROUP BY C_name
ORDER BY SUM(S_num)DESC
如果是2005有更好的方式