sql²éѯ

±í½á¹¹
    ID    NAME

    1    ÕÅÈý
    1    ÀîËÄ
    2    ÕÅÈý


ÎÒÏëͬʱÂú×ãnameµÈÓÚ'ÕÅÈý'ºÍ'ÀîËÄ' µÃµ½ID=1
ID 2²»³öÀ´

---

SQL code:
SELECT ID from TB GROUP BY ID HAVING COUNT(NAME)>=2

---

SQL code:
select id
from tb
where name in('ÕÅÈý','ÀîËÄ')
group by id
having count(distinct name)=2

---

¶¥77

---

SELECT ID from tb GROUP BY ID HAVING COUNT(fullname)>=2 ½á¹û³öÀ´ÊÇ1 2  µ«ÊÇÎÒֻϣÍû³öÀ´½á¹ûÊÇ1

---

SQL code:


select id from tb a
where exists(select 1 from tb b where a.id=b.id and a.name <>b.name)

--ÕâÑù£¿

---

ÒýÓÃ

SELECT ID from tb GROUP BY ID HAVING COUNT(fullname)>=2 ½á¹û³öÀ´ÊÇ1 2  µ«ÊÇÎÒֻϣÍû³öÀ´½á¹ûÊÇ1

ÊÔÊÔ2Â¥

---

ÎÒÒ²¶¥77£¬Ë³±ã°ïÎÒ½â¾öÏÂÀ§ÄÑ°É

---

ÒýÓÃ

SQL codeselect idfrom tbwhere namein('ÕÅÈý','ÀîËÄ')groupby idhavingcount(distinct name)=2