[Quote=引用 3 楼 wubudang 的回复:]
引用 2 楼 wubudang 的回复:
select * from (select row_number() over(partition by 第一列字段 order by 时间 asc) as row_number,* from 表)a where row_number=1
[Quote=引用 2 楼 wubudang 的回复:]
select * from (select row_number() over(partition by 第一列字段 order by 时间 asc) as row_number,* from 表)a where row_number=1
[/Quote]
sql 2005可以,2000的话用1L的方法