菜鸟 求一查询语句

[lcw321]

table_a(a b c)
dd -1 30
dd 1 30
ff 3 40
ee -2 20
ee 2 20
......................

我想得到table_a中没有成对出现的ff的这一行数据

[CSDMN]

select a.* from table_a a,(select a from table_a group by a having count(*)=1) as t
where a.a=t.a

[chuifengde]

select * from table_a where a in(select a from table_a group by a having count(1)=1)

[dawugui]

select * from table_a as m,
(select a , count(*) from table_a group by a having count(*) < 2) n
where m.a = n.a

[marco08]

select a from table_a group by a having count(a)>1

[chenjunjarysky]

select a.* from table_a a,(select a from table_a group by a having count(*)=1) as t
where a.a=t.a

[dulei115]

select a.*
from table_a a left join table_b b on a.a = b.a and a.b = -b.b and a.c = b.c
where b.a is null

[xshsoft]

CREATE TABLE table_a
(
a CHAR(2),
b INT,
c INT
)
GO
INSERT INTO table_a
SELECT 'dd', -1, 30 UNION ALL
SELECT 'dd', 1, 30 UNION ALL
SELECT 'ff', 3, 40 UNION ALL
SELECT 'ee', -2, 20 UNION ALL
SELECT 'ee', 2, 20 UNION ALL
SELECT 'cc', 2, 40
GO
SELECT table_a.*
FROM table_a,(SELECT a FROM table_a GROUP BY a HAVING COUNT(a)<2) b
WHERE
table_a.a=b.a
GO
DROP TABLE table_a

[lcw321]

抱歉了,我这个数据中可能有
table_a(a b c)
dd -1 30
dd 1 30
ff 3 40
ee -2 20
ee 2 20
dd -1 30
dd 1 30
ff -4 40

......................

也就是说可能重复出现"对"(dd) 以及重复出现的 单一记录 (ff)
要的记录是
ff 3 40
ff -4 40

[dulei115]

select a.*
from table_a a left join table_b b on a.a = b.a and a.b = -b.b and a.c = b.c
where b.a is null

[chuifengde]

select * from table_a g where not exists(select 1 from table_a where a=g.a and b=-g.b)

[xshsoft]

哦.原来是这样.

[早起晚睡]

来晚了

[lcw321]

怎么你们这么牛呢

[xshsoft]

同意 树上的鸟儿

[lcw321]

郁闷给不了分啊，提示与给的分值不对，可是明明是对的啊，不过

该问题的总分值：２０　
现在可给的分值：NaN


现在可给的分值：NaN　　NaN好象不对了哦？