先执行 SELECT count([ID]) FROM TradeList group by [seller_nick]
得到如下一列数据:
2
13
31328
71
4537
530
1再取这一列数据中最小的 就是 1尝试了这么写 SELECT min(count([ID])),[seller_nick] FROM TradeList group by [seller_nick]
但是 不能对包含聚合或子查询的表达式执行聚合函数。 有没有其他方法 一句sql能实现上面功能的? 麻烦高手帮忙解答下
得到如下一列数据:
2
13
31328
71
4537
530
1再取这一列数据中最小的 就是 1尝试了这么写 SELECT min(count([ID])),[seller_nick] FROM TradeList group by [seller_nick]
但是 不能对包含聚合或子查询的表达式执行聚合函数。 有没有其他方法 一句sql能实现上面功能的? 麻烦高手帮忙解答下
SELECT count([ID]) FROM as [count] TradeList group by [seller_nick]
)t
select min([count]) from(
SELECT count([ID]) as [count] FROM TradeList group by [seller_nick]
)t
SELECT TOP 1 count([ID]) FROM TradeList group by [seller_nick]
ORDER BY count([ID]) ASC
SELECT count([ID]) id ,[seller_nick] FROM TradeList group by [seller_nick])a
SELECT count([ID]) as [count] FROM TradeList group by [seller_nick]
) t还有一个问题 就是能不能连 seller_nick列 一起查出来