[阅读: 402] 2006-10-26 05:03:10
懒得改成通用的模式了.
id是用sequence生成的,所以有先后关系.
select rf.repair_form_id, rf.user_mob_imei, rf.user_mob_imei_new,rf.enabled_flag,rf.is_submit
from mas_admin.asc_repair_form rf
start with rf.user_mob_imei_new = '190407747328' -- 327162000648 190407747328
connect by prior rf.user_mob_imei = rf.user_mob_imei_new
and prior rf.repair_form_id > rf.repair_form_id