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;
转自:Oracle以某字段实现数据排序(oracle以某字段排序)-数据库运维技术服务 (dbs724.com)
标签:name,ASC,按字段,Oracle,排序,ORDER,SELECT From: https://www.cnblogs.com/wwssgg/p/17699654.html