select row_number() over (partition by t.parent_id order by t.parent_id,t.order_no) rowno, t.id,t.parent_id
from SJ_TASK_BOOK_DETAIL t
上面是按照父ID【parent_id】来分组,针对每一组数据来生成自己的行号,生成结果如下图:
select row_number() over (partition by t.parent_id order by t.parent_id,t.order_no) rowno, t.id,t.parent_id
from SJ_TASK_BOOK_DETAIL t
上面是按照父ID【parent_id】来分组,针对每一组数据来生成自己的行号,生成结果如下图: