select * from (select subject ,row_number() over(order by gread) as rowidid
from testtest) x
subject ,row_number() over(order by gread) as rowidid
from testtest 的分析:
第一步:
select subject from testtest order by gread
第二步:
添加行号
select * from (select subject ,row_number() over(order by gread) as rowidid
from testtest) x
subject ,row_number() over(order by gread) as rowidid
from testtest 的分析:
第一步:
select subject from testtest order by gread
第二步:
添加行号