求一简单的sql语句

[YAMABACK]

一个表有a,b,c,d,e五个字段，a是关键字，但是想得到b,c组合的唯一的记录，例如：

1，21，22，40，50
2，21，22，49，40
3，21，20，33，40
4，22，30，55，52
……………………

希望得到第1,2条记录

[LJWS]

不明白你的意思

[kookboy]

是唯一还是不唯一呀,楼主
select distinct A.* from tablename A,tablename A
where A.b = B.b and A.c = B.c and A.a <> B.a

[kookboy]

上面是不唯一的,下面是唯一的
select distinct A.* from tablename A,tablename A
where (A.b <> B.b or A.c <> B.c) and A.a <> B.a

[hsh_boy]

说明白一点,把你要的结果打出来

[xuam]

select * from tablename where exists (select cast(b as char)+cast(c as char) from tablename having count(cast(b as char)+cast(c as char))>1)

[mgsray]

select * from table ta,(select b, c from table group by b,c having count(1)>1) tb
where ta.b=tb.b and ta.c=tb.c

[YAMABACK]

抱歉，是想得到第1，3，4条记录

[LJWS]

select * from [table] a join (
select b,c,min(id) as id from [table] group by b,c) b
on a.id=b.id

[mulitao521]

select distinct b,c from table

[chd2001]

select min(a) a,b,c from TableName group by b,c order by a

[chd2001]

这个语句才能得到标准答案：
select a,b,c,d,e from TableName1 join (
select min(a) f from TableName1 group by b,c) TableName2
on TableName13.a=TableName2.f