怎么将表中的数据进行筛选,例如中第一列的多行数据都一样,但是后面的时间不一样,如何进行去重,取时间距离当前时间最近的一条
SqlServer?oracle?mysql?
---------
SqlServer为例(其它的不清楚)
select lot_code,max(arrive_date) [new_] from tablename group by lot_code
除了楼上办法,还可以用row_number() over (partition by 重复字段 order by 排序字段)函数来搞select * from (
select *,row_number() over (partition by lot_code order by arrive_date desc) as dateno from tablename ) s where dateno =1