100分求sql,特急!!!!!!!!!!!!

[jzhan]

field1 field2 field3 field4 field5 field6 field7 field8
1|1 15 400 C1-FG-05-9789 1 18758.1 18758 255
2|1 15 400 C1-FG-05-9789 1 18767.1.1 18767 545
3|2 12 400 C1-FG-05-9789 2 18758.1 18758 255
4|2 12 400 C1-FG-05-9789 2 18767.1.1 18767 545
5|2 12 400 C1-FG-05-9790 1 18762.1.1 18762 364
6|2 12 400 C1-FG-05-9790 1 18767.1 18767 36
7|2 12 400 C1-FG-05-9792 1 18762.1 18762 78
8|2 12 400 C1-FG-05-9792 1 18765.1.1 18765 322

"|"号前的是记录的行数,怎么才能让select的结果只显示field6中的不同的记录(也就是不显示第3,4条记录)
不能用where field5<>2或where field5=1
望高手赐教!!!
如果觉得分数不够我手头有500分,再开贴给!!

[renaski]

select field6 ,field1, field2 ,field3 ,field4 ,field5,field7,field8 from table1 group by field6 ,field1, field2 ,field3 ,field4 ,field5,field7,field8 order by substring(field1,1,1) asc

[mib3000]

就这么多数据么？行号会不会是多位数

[renaski]

select * from table1 where field6 in (select distinct field6 from table1) order by substring(field1,1,1) asc

[yangys]

select #aa.* from #aa
inner join
(select min(field1)as field1, field6from #aa group by field6)bb
on #aa.field1=bb.field1

[renaski]

select field6 ,field1, field2 ,field3 ,field4 ,field5,field7,field8 from table1 group by field6 ,field1, field2 ,field3 ,field4 ,field5,field7,field8 order by field1 asc


--或者
select * from table1 where field6 in (select distinct field6 from table1) order by field1 asc

[renaski]

select * from table1 where field6 in (select distinct field6 from table1) order by field1 asc

不好意思，这个错了

[mib3000]

行号存在多位数时不好办，如不存在 杨杨 的就可以

[jzhan]

谢谢各位
这个问题我自己已经解决了,
但本着 雁过留毛,回者有分的原则散分.