select aa.a,aa.b from table aa inner join (select min(a) as a from table group by c) bb on…… <- 中国开发网

CNDEV.ORG

中国开发网: 论坛: 程序员情感CBD: 贴子 308623

sea026：

select aa.a,aa.b from table aa inner join (select min(a) as a from table group by c) bb on……

[阅读: 501] 2006-04-07 03:30:42

select aa.a,aa.b
from table aa
inner join
(
select min(a) as a from table group by c
) bb on bb.a=aa.a