我想通过事件获取名为ppno的字段的记录。即。
(GIVE ME RECORDS WHERE PPNO repeating same 5 times)
像这样
Name PPNO
John TNi89873
Smith TNi89873
Mark TNi89873
Joe TNi89873
Cane TNi89873
Mary OCSV
Mark OCSV
Don OCSV
Crook OCSV
Mike OCSV
最佳答案
像这样
select * from tbl where ppno in
(select ppno from tbl group by ppno having count(ppno) > 4)