ÇóÒ»ÌõSQLÓï¾ä

ÎÒÒªÔÚÊý¾Ý¿âÀï²éÕÒÐÕÃûºÍµØÖ·ÏàͬµÄÊý¾Ý£¬²¢ËùÓÐÕâЩÊý¾ÝÕÒ³öÀ´¡£¸ÃÔõôŪ

---

Êǿ⻹ÊÇ±í£¿

---

Êý¾Ý¿âÀ¡¡
ÊÇËùÓбíÀïÃæÂð£¿

---

¸ø³öÒ»¸ö¼òµ¥µÄ±í½á¹¹ºÍÊý¾Ý³öÀ´£¬ÕâÑù´ó¼ÒºÜÈÝÒ×Ã÷°×ÄãµÄÒâ˼£¡

---

ÒýÓÃ

ÎÒÒªÔÚÊý¾Ý¿âÀï²éÕÒÐÕÃûºÍµØÖ·ÏàͬµÄÊý¾Ý£¬²¢ËùÓÐÕâЩÊý¾ÝÕÒ³öÀ´¡£¸ÃÔõôŪ

--Ö»²éѯÐÕÃû,µØÖ·
select ÐÕÃû,µØÖ· from tb group by ÐÕÃû,µØÖ· having count(1) > 1

--²éѯËùÓÐÄÚÈÝ
select t.* from tb t where exists(select 1 from
(
  select ÐÕÃû,µØÖ· from tb group by ÐÕÃû,µØÖ· having count(1) > 1
) m where ÐÕÃû = t.ÐÕÃû and µØÖ· = t.µØÖ·
)

---

ÐÕÃû=µØÖ·

---

??SQL code:
SELECT *
from TB A JOIN
(
SELECT ÐÕÃû,µØÖ·
from TB
GROUP BY ÐÕÃû,µØÖ·
HAVING COUNT(1)>=2
) B
ON A.ÐÕÃû=B.ÐÕÃû AND
A.µØÖ·=B.µØÖ·

---

http://blog.csdn.net/fredrickhu/archive/2009/09/20/4574197.aspx

---

ѧϰÁË~~

---

ÊDZíÀ²»ºÃÒâ˼¡£´ó¼Ò»Ø´ðµÄÌ«¿ìÁË¡£

---

SELECT *
from 11ÔÂ2ÈÕÒÑ·¢»õ$ a
WHERE EXISTS
          (SELECT *
        from 11ÔÂ2ÈÕÒÑ·¢»õ$
        WHERE a.ÊÕ¼þÈË = ÊÕ¼þÈË AND a.ÊÕ¼þµØÖ· = ÊÕ¼þµØÖ· AND ÐòºÅ <> a.ÐòºÅ)
ÎÒÓÃÕâ¸öÊÇ¿ÉÒÔ²