这个sql语句怎么写？？？过滤重复记录的

Question

SELECT A,B,MIN(C) From TableName GROUP BY A,B

Answer 1

还有问题，如果我再加一句：
insert abc values("a1","b2","c2")
这个记录也会被返回，但这不是我想要的我只想过滤a重复的c取最小的，b就随c了

Answer 2

insert abc values("a1","b3","c1")
insert abc values("a1","b1","c2")
insert abc values("a1","b4","c1")
insert abc values("a1","b2","c1")
insert abc values("a1","b2","c2")
insert abc values("a1","b3","c2")你要哪条？
也就是说b怎么处理？
a1,b1,c1可以吗？这条记录是造的。

Answer 3

select * from TableName x where 
c=(select min(c) as c from TableName where a=x.a)
and b=(select min(b) as b from TableName where a=x.a and c=x.c)呵呵！

Answer 4

大家好,请问如何把复制的记录过滤掉..
记录如下
*************************************
insert abc values("a1","b3","c2341")
insert abc values("a1","b2","c2431")
insert abc values("a1","b3","c2341")
insert abc values("a1","b3","c24231")
insert abc values("a1","b13","c231")
insert abc values("a1","b2342","c234231")
***************************************
现在a1是复制的,我只想要一条....

Answer 5

大家好,请问如何把复制的记录过滤掉..
记录如下*************************************
字段为:a,b,c,dinsert abc values("a1","b3","c2341","asdfasdf")
insert abc values("a1","b2","c2431","asdfsadf")
insert abc values("a1","b3","c2341","sadfsadfsadfsadf")
insert abc values("a1","b3","c24231,"asdfasdfsadfsadf")
insert abc values("a1","b13","c231")
insert abc values("a1","b2342","c234231")
insert abc values("a2","b3","c2341","asdfasdf")
insert abc values("a2","b2","c2431","asdfsadf")
insert abc values("a2","b3","c2341","sadfsadfsadfsadf")
insert abc values("a2","b3","c24231,"asdfasdfsadfsadf")
insert abc values("a2","b13","c231")
insert abc values("a2","b2342","c234231")***************************************
现在a字段有重复记录,我只想要重复中的任意一条...."a1","b3","c2341","asdfasdf"
"a2","b3","c2341","asdfasdf"其中c,d字段为备注字段?