查询titles表中pub_id出现次数超过6次以上的记录如题``[解决办法]select * from titles where pub_id in(s
查询titles表中pub_id出现次数超过6次以上的记录
如题``
[解决办法]
select * from titles where pub_id in
(
select pub_id from titles group by pub_id
having count(*)> 6
)
[解决办法]
select pub_id from 表 group by pub_id having count(pub_id)> 6