select tt.*,tt.rn from
(select t.reg_id,row_number() over (order by t.reg_id) rn from t_reg_photo t ) tt
(select t.reg_id,row_number() over (order by t.reg_id) rn from t_reg_photo t ) tt
where tt.reg_id =10
用over函数和row_number来查询就好了