select max(__tempTable.__rowIndex) as rowCount
from ( select *, row_number() over(order by id) as __rowIndex from tableName) as __tempTable
select *
from ( select *, row_number() over(order by id) as __rowIndex from tableName) as __tempTable
where __tempTable.__rowIndex > 0 and __tempTable.__rowIndex < 10
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
