表名: stu_card结构和值如下:card_name card_value
----------------------------
aa 100
aa 0
bb 100
bb 0
cc 100
dd 0
ee 100
ee 0
ff 100
gg 0只有这一个表,需要从中找出值只有100的记录。如cc,ff得到结果如下
card_name card_value
----------------------------
cc 100
ff 100
----------------------------
aa 100
aa 0
bb 100
bb 0
cc 100
dd 0
ee 100
ee 0
ff 100
gg 0只有这一个表,需要从中找出值只有100的记录。如cc,ff得到结果如下
card_name card_value
----------------------------
cc 100
ff 100
select * from stu_card where card_value = 100
关键字 intersect
and card_name in('cc','ff')
一起进步
and card_name not in (
select card_name from stu_card where card_value=0 )
select * from stu_card where card_value=100 and card_name not in(select card_name from stu_card group by card_name having count(*) > 1)