PostgreSQL ORDER BY
ORDER BY 排序:ASC 升序默认,DESC 降序;可按多列、表达式或列序号排序。
Key PointsPostgreSQL,ORDER BY,排序,NULLS LAST
讲解
ORDER BY 排序:ASC 升序默认,DESC 降序;可按多列、表达式或列序号排序。
示例
SQL
SELECT name, salary FROM company ORDER BY salary DESC NULLS LAST;Output
name | salary
------+--------
Tom | 8000.00讲解
ORDER BY 排序:ASC 升序默认,DESC 降序;可按多列、表达式或列序号排序。
示例
SQL
SELECT name, salary FROM company ORDER BY salary DESC NULLS LAST;Output
name | salary
------+--------
Tom | 8000.00