【数据库_Postgresql】sql查询结果添加序号列

ROW_NUMBER () OVER (ORDER BY A .ordernumber ASC) AS 序号