Question

VFP的查询设计器里，以下筛选表达式怎么编写？

SELECT 作者编号 FROM BOOKS GROUP BY 作者编号 HAVING COUNT(*)>=3

Answer 1

SELECT 作者编号 FROM BOOKS GROUP BY 作者编号 HAVING COUNT(作者编号)>=3

Answer 2

SELECT 作者编号,COUNT(*) as c FROM BOOKS GROUP BY 作者编号 HAVING c>=3