1、查询不重复的字段
select distinct name from table
2、查询某个字段不重复的,所有内容
sql根据某一个字段重复只取第一条数据
select s.*
from (
select *, row_number() over (partition by [code_ironladel] order by [time_create] desc) as group_idx
from View_track
) s
where s.group_idx = 1