我有一个SQL语句,它可以计算组数,但我想筛选出组数大于1的数据,请问有谁能帮忙,因为当前代码不能得到正确结果?
select Code, Qty, Count(Qty) from Product where ItemName = 'Banana'
and Count(Qty) > 1
Group by Code, Qty order by 3 desc
Qty
分组吗? - Mureinik