求sql 查询出相同值的字段 且相同次数大于2的 如:

2024-11-29 02:47:18
推荐回答(1个)
回答1:

Select * from table where field in

(Select field from table having count(filed)>2 group by field)