--你的表中没有主键?select id=identity(int,1,1),aInt,aText into #t from tableselect a.aInt,a.aText from #t a,(select id=min(id) from #t group by aInt)b where a.id=b.iddrop table #t
--如果表中有主键select a.aInt,a.aText from table a,(select 主键=min(主键) from table group by aInt)b where a.主键=b.主键
where a.id=b.iddrop table #t
from table a,(select 主键=min(主键) from table group by aInt)b
where a.主键=b.主键