有表A:
a b c
1 33 kk
2 33 kk
3 33 mm
4 55 mm
5 66 kk
6 66 ff要得到以下结果:
a b c
3 33 mm
5 66 kk
6 66 ff即查出b列相同而c列不同的记录
a b c
1 33 kk
2 33 kk
3 33 mm
4 55 mm
5 66 kk
6 66 ff要得到以下结果:
a b c
3 33 mm
5 66 kk
6 66 ff即查出b列相同而c列不同的记录
from A m,A n
where m.b = n.b and m.c <> n.c
order by m.a
from A m,A n
where m.b = n.b and m.c <> n.c
and not exists
(
select b,c
from A
where b = m.b and c = m.c
group by b,c
having COUNT(*) > 1
)
order by m.a