Oracle去除重复(某一列的值重复),取最新(日期字段最新)的一条数据

– 根据时间查询最新的数据，去除重复旧数据
select *
from INSPECTOR_ASSESSMENT
where create_time = (select MAX(create_time) from INSPECTOR_ASSESSMENT group by id_card)
order by create_time desc

– N条数据修改（ ‘=’ 修改为 ‘ in ’ ）
select *
from INSPECTOR_ASSESSMENT
where create_time in (select MAX(create_time) from INSPECTOR_ASSESSMENT group by id_card)
order by create_time desc

例子：
select * from [table]
where [time] = (select MAX( [time] ) from [table] group by [需要去除重复的数据字段])
order by [time] desc

注释：
[table] = 表名
[time] = 你的时间字段
[需要去除重复的数据字段] = 需要去除重复的字段，我这里是身份证号码（id_card）

欢迎交流。