清华大佬耗费三个月吐血整理的几百G的资源，免费分享！....>>>

#查询一个表中的两个字段值相同的数据
select p1.cityname from forecast p1,forecast p2 where p1.cityname=p2.cityname and p1.cityname=p2.cityname and p1.id!=p2.id;