oracle 排序解决方法_Oracle开发

oracle 排序
假设数据如下：
ID DIV NUM
1 1 1
1 2 1
2 1 3
2 2 3
3 1 2
3 2 2

每个ID 下均有DIV 1,2
保持这样的格式，再以num排序

怎样得到如下结果
1 1 1
1 2 1
3 1 2
3 2 2
2 1 3
2 2 3

------解决方案--------------------

SQL code

with t1 as (     select 1 id,1 div,1 num from dual     union all     select 1 id,2 div,1 num from dual     union all     select 2 id,1 div,3 num from dual     union all     select 2 id,2 div,3 num from dual     union all     select 3 id,1 div,2 num from dual     union all     select 3 id,2 div,2 num from dual)select * from t1order by num,div    id    div    num---------------------------1    1    1    12    1    2    13    3    1    24    3    2    25    2    1    36    2    2    3
------解决方案--------------------
SQL code--如果每一组内num的值都是相同的话，这个sql就可以了select * from t1order by num,div