select * from (select t.*,row_number() over(partition by t.type order by 1) rn from a.t_trade_order t ) where rn<=1 ;
转载于:https://my.oschina.net/u/2274056/blog/1842538
select * from (select t.*,row_number() over(partition by t.type order by 1) rn from a.t_trade_order t ) where rn<=1 ;
转载于:https://my.oschina.net/u/2274056/blog/1842538