分页sql汇总
时间:2021-07-01 10:21:17
帮助过:14人阅读
from
(select
*,isnull(punish_amount,0)+isnull(forf_amount,0) as
amount, row_number() over(order by
id) as
rownumber from
case_info) a where rownumber > 40 and rownumber <50来自为知笔记(Wiz)
分页sql汇总
标签:title case normal gre .sql student res nis limit