sqlÓï¾äÎÊÌâ

ÓÐÒ»¸ö±íAA
name  tj
1    a
1    b
1    c
2    a
2    d
3    b
ÒªÇóµ±tj×ֶεÄÖµ¼ÈµÈÓÚaÓÖµÈÓÚcʱ£¨tj = ¡®a¡¯ÓÖÒªtj = ¡®b¡¯£©
Ò²¾ÍÊÇ˵ÎҵIJéѯÌõ¼þÊÇa¡¢c£¬ÎÒÒª²éµÄ½á¹ûÊÇ1

---

SQL code:
select name from
(
select distinct name from aa where tj ='a'
union all
select distinct name from aa where tj ='b'
) t
group by name having count(1) = 2

---

SQL code:

select * from AA where tj='a' and tj='c'

---

ÒýÓÃ

SQL codeselect*from AAwhere tj='a'and tj='c'

Àí½â錯誤.´ó烏龜Õý½â.

---

ÒýÓÃ

SQL codeselect namefrom
(selectdistinct namefrom aawhere tj='a'unionallselectdistinct namefrom aawhere tj='b'
) tgroupby namehavingcount(1)=2

up

---

SQL code:
create table aa(name int, tj varchar(10))
insert into aa values(1 , 'a')
insert into aa values(1 , 'b')
insert into aa values(1 , 'c')
ins