select min([count]) from(
SELECT count([ID]) as [count] FROM  TradeList group by [seller_nick]
)t

------解决方案--------------------
嵌套查询即可。

------解决方案--------------------
SQL code

SELECT TOP 1 count([ID]) FROM TradeList group by [seller_nick]
ORDER BY count([ID]) ASC

------解决方案--------------------
SQL code
select MIN (ID),[seller_nick]from (
SELECT count([ID]) id ,[seller_nick] FROM TradeList group by [seller_nick])a

------解决方案--------------------

探讨


SQL code

SELECT TOP 1 count([ID]) FROM TradeList group by [seller_nick]
ORDER BY count([ID]) ASC