找出不同的记录

[hongyuan20022003]

表格如下：
s e aa bb cc
0 1 3 4 6
2 4 6 6 4
............

s\e\aa\bb\cc均为正整数，

有两个这样的表格，hh和gg

select distinct s,e,aa,bb,cc from hh
记录数为108
select distinct s,e,aa,bb,cc from gg
记录数为107


select distinct s,e,aa,bb from hh
记录数为36
select distinct s,e,aa,bb from gg
记录数为36


怎样找出表格hh中独有（gg中没有）的记录？

[Moose]

select hh.*
from hh
left join gg on gg.cc = hh.cc
where gg.cc is null

[hongyuan20022003]

cc的范围是-1/0/1

[中国风]

select * from hh where checksum(s,e,aa,bb,cc) not in(select checksum(s,e,aa,bb,cc) from gg)

select * from hh where checksum(s,e,aa,bb) not in(select checksum(s,e,aa,bb) from gg)

[zheninchangjiang]

select distinct s,e,aa,bb from hh
记录数为36
select distinct s,e,aa,bb from gg
记录数为36
这个并不能证明前面4列的相同性，所以还得：
select * from hh a where not exists(select 1 from gg where s=a.s and e=a.e and aa=a.aa and bb=a.bb and cc=a.cc)

[中国风]

select distinct s,e,aa,bb,cc from hh where checksum(s,e,aa,bb,cc) not int (select checksum(s,e,aa,bb,cc) from gg)

select distinct s,e,aa,bb from hh where checksum(s,e,aa,bb) not in(select checksum(s,e,aa,bb) from gg)

或

select 
	distinct s,e,aa,bb,cc 
from 
	hh 
where
	 not exists (select 1 from gg where s=hh.s and e=hh.e and  aa=hh.aa and bb=hh.bb and cc=hh.cc)

select 
	distinct s,e,aa,bb,cc 
from 
	hh 
where
	 not exists (select 1 from gg where s=hh.s and e=hh.e and  aa=hh.aa and bb=hh.bb)

[Moose]

select hh.*
from hh
left join gg
on gg.cc=hh.cc
and gg.s=hh.s
and gg.e=hh.e
and gg.aa=hh.aa
and gg.bb=hh.bb
where gg.cc is null