i want to get the record of each model where the code is minimum?

[jackyji]

there is a table：
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

i want to get the record of each model where the code is minimum.
the result is:
code model remark
1 a x
4 b z
6 c y
how can i write the sql?

[hvle]

select code, model, remark from tablename group by model order by code;