sql根据某一个字段重复只取第一条数据
例如根据表table_name中的name是否重复,根据创建时间取最新的一条:select s.* from ( select *, row_number() over (partition by [名称] order by [创建时间] desc ) as group_idx from table_name) swhere s.group_idx = 1若取最原始的一条,则order by xxx asc...