select * from (SELECT
* ,
ROW_NUMBER ( ) OVER ( PARTITION BY lob_no ORDER BY ts DESC ) AS rn
FROM
`bd_talent`) where rn = 1
根据条件lob通过ts排序为结果赋值顺序
select * from (SELECT
* ,
ROW_NUMBER ( ) OVER ( PARTITION BY lob_no ORDER BY ts DESC ) AS rn
FROM
`bd_talent`) where rn = 1
根据条件lob通过ts排序为结果赋值顺序