zhiyuan

摘要： --统计重复出现了几次 SELECT Eid,COUNT(Eid) As EidCount FROM ( select eid,hotel from cii_hotel_eidhotel ) X GROUP BY Eid HAVING COUNT(Eid)>1 --去除重复行 SELECT Eid,Hotel FROM ( select eid,hotel from c... 阅读全文