PostgreSQL 拼接后,去重再给查询列表增加序号
PostgreSQL 拼接后,去重再给查询列表增加序号
select ROW_NUMBER() over(ORDER bY numberPlate ) AS num,ROW_NUMBER() over(ORDER bY numberPlate asc ) AS key,numberPlate from
(select DISTINCT concat_ws('','[',concat_ws(']',(select bus_code from san_vehicle where id = sps.r
原创
2021-08-25 14:34:38 ·
452 阅读 ·
0 评论