select * from (
select row_number() over(partition by eci order by eci) rn ,eci, gridx,gridy from 表明 where
p_day=to_date('2017-12-20','yyyy-MM-dd')
)t where rn =1
select * from (
select row_number() over(partition by eci order by eci) rn ,eci, gridx,gridy from 表明 where
p_day=to_date('2017-12-20','yyyy-MM-dd')
)t where rn =1
转载于:https://www.cnblogs.com/dushaojun/p/8324323.html