从字段name值相同的记录中查询最新创建的记录
select * from(
select row_number() over(partition by name order by createDate desc) idx,* from userHistory
) a where idx=1
从字段name值相同的记录中查询最新创建的记录
select * from(
select row_number() over(partition by name order by createDate desc) idx,* from userHistory
) a where idx=1