Question

oracle中sql语句的排序问题

我具体说一下我想要的是什么吧，不能上传图片，所以就口述了，在数据库中有一个表CP，对应数据是这样
classcode parclasscode paixu
01 10 1
02 10 2
03 11 1
04 11 2
05 11 3
10 00 1
11 00 2
parclasscode为oo的为父字段，classcode=01,02,03,04,05的为子字段，相信大家可以看懂吧，现在就是想在页面中输出
parclasscode paixu classcode paixu
10 1 01 1
10 1 02 2
11 2 03 1
11 2 04 2
11 2 05 3
在线等，谢谢

Answer 1

SELECT B.parclasscode,A.paixu,B.classcode,B.paixu
from
(SELECT * FROM aaa WHERE parclasscode = '00') A,
(SELECT * FROM aaa WHERE parclasscode <> '00') B
WHERE A.classcode = B.parclasscode
order by A.paixu,B.paixu

Answer 2

select c.parclasscode,
case
when c.parclasscode = 10 then
1
when c.parclasscode = 11 then
2
end paixu,
c.classcode,
c.paixu
from cp c
where c.parclasscode in (10, 11);

Answer 3

select par.classcode,par.paixu,cp.classcode,cp.paixu from cp par
left join cp
on cp.parclasscode=par.classcode
where par.parclasscode='00'
order by par.paixu,cp.paixu