sql语句问题

有一个表AA
name  tj
1    a
1    b
1    c
2    a
2    d
3    b
要求当tj字段的值既等于a又等于c时（tj = ‘a’又要tj = ‘b’）
也就是说我的查询条件是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