partition用法

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