select
row_number() over(order by 1) as id,
a.* from dp_ipo_tmp.tmp_ipo_yekuai_118_2018q4_06 a where Finterest_date <= '2018-12-31'
代码line2所示,即为添加的自增id列
select
row_number() over(order by 1) as id,
a.* from dp_ipo_tmp.tmp_ipo_yekuai_118_2018q4_06 a where Finterest_date <= '2018-12-31'
代码line2所示,即为添加的自增id列