Oracle 按字段排序
1. 单一字段排序
在Oracle数据库中,我们可以通过ORDER BY子句来对查询结果进行排序。ORDER BY子句的基本语法如下:
SELECT column_name(s) FROM table_name ORDER BY column_name [ASC|DESC];
SELECT * FROM student ORDER BY age ASC;
2. 多字段排序
SELECT * FROM student ORDER BY age ASC, stu_id ASC;
SELECT * FROM student ORDER BY name COLLATE chinese_pinyin_m;