请问该sql语句怎么写

[zealothasu]

a b c d
------------------------
AA 1 LL DD
AA 3 DD KK
BB 3 DD KJK
BB 2 SS DM
CC 9 AA MM

查询结果应该是
AA 1 LL DD
BB 2 SS KJK
CC 9 AA MM
也就是要把a列有相同值但字段b中最小的那一行查询出来

我用select a, min(b) from table1 group by a
可以把a, b两列查出来
但要是加上c,d列就不行了


那么怎么写？？

[Rewiah]

select * from tablename x
where b=(
select min(b) from tablename
where a=x.a
)

[Rewiah]

需要的话加
order by a

[teaism]

select a.* from table1 a,(select a, min(b) as b from table1 group by a
) b where a.a=b.a and a.b=b.b

[SophiaWang]

select * from table1
where b = ( select min(b) from table1 group by a )

[caiyunxia]

我用select distinct a.* from table1 a ,(select a,min(b) from table1 group by a) b
where a.a=b.a and a.b=b.b

[SophiaWang]

select * from table1 b
where b = ( select min(b) from table1 where b.a = a group by a )

[zealothasu]

谢谢大家的热情

[mjhnet]

感觉乘长风的方法比较好