查询一个表中不相等的记录

[灿烂阳光168]

假如有一表如下所示：

product month number
aa 2 30
aa 3 60

bb 2 30
bb 3 30

需要查找出number不相同的2，3月份的记录，查询的记录为：

product month number
aa 2 30
aa 3 60


求SQL语句。

[jia_guijun]

select a.* from tb a join tb b on a.product=b.product and a.number<>b.number and a.month in(2,3)

[Tomzzu]

1楼正解, 已经写得很完美了

[ws_hgo]

create table #TT
(
  product varchar(10),
  [month] int,
  number int
)
insert into #TT select 'aa',2,30
union all select 'aa',3,60
union all select 'bb',2,30
union all select 'bb',3,30

 select * from #TT t where exists (select * from #TT where t.product=product and number<>t.number) and [month] in(2,3)

product    month       number
---------- ----------- -----------
aa         2           30
aa         3           60

(2 行受影响)