access查询图书表中各出版社图书的数目,要求过滤掉数目为1的数据

2025-04-27 09:47:06
推荐回答(1个)
回答1:

SELECT 出版社, COUNT(1) FROM TABLE GROUP BY 出版社 HAVING COUNT(1)>1
用group by having解决
祝好运,望采纳