SELECT
t.id,
any_value ( pp.xx_opin ) xxx_opin
FROM
sys_xxx t
LEFT JOIN xxx pp ON t.id = pp.xxx_id
GROUP BY
t.id
ORDER BY
t.modified_date DESC
any_value()会选择被分到同一组的数据里第一条数据的指定列值作为返回数据
SELECT
t.id,
any_value ( pp.xx_opin ) xxx_opin
FROM
sys_xxx t
LEFT JOIN xxx pp ON t.id = pp.xxx_id
GROUP BY
t.id
ORDER BY
t.modified_date DESC
any_value()会选择被分到同一组的数据里第一条数据的指定列值作为返回数据