【MSSql2000】select

select a.* from tabname a where a.标识字段 in(select top 1 标识字段 from tabname where 分组字段 = a.分组字段)