取出每一种model的code最小的记录的sql语句？

[mikeji]

有一张表如下：
code model remark
1 a x
2 a x
3 a x
4 b z
5 b z
6 c y
7 c y
8 c y

我想取出每一种model的code最小的记录，即表中的：
code model remark
1 a x
4 b z
6 c y
sql应该怎么写比较好呢？

[postren]

select min(code) as code, model, remark from table1
group by model, remark

[梅青松]

create table test
(
code int not null ,
mode varchar(20) null,
remark varchar(20) null
)
insert into test
select 1, 'a', 'x'
union select 2, 'a', 'x'
union select 3, 'a', 'x'
union select 4, 'b', 'z'
union select 5, 'b', 'z'
union select 6, 'c', 'y'
union select 7, 'c', 'y'
union select 8, 'c', 'y'

-------------------------------------------
select code = min(code), mode, remark=min(remark)
from test
group by mode
-------------------------------------------
drop table test


結果;
1 a x
4 b z
6 c y