oracle多个order by

Question

oracle多个order by

Answer 1

一条sql中一个order by 除非你是子查询，嵌套的子查询……比如已name 升序，age降序排序order by name asc,age desc 即可 ASC升序 默认就是这个，DESC降序