select temp_aad2.vir_id from (
select temp_aad1.vir_id,rownum row_id from (
select vir_id from ${tableName} where ${query}) temp_aad1) tmp_add2
)where mod(tem_add2.row_id,#{mod,jdbcType=INTEGER})=0
取模查询
最新推荐文章于 2023-03-09 15:15:31 发布
select temp_aad2.vir_id from (
select temp_aad1.vir_id,rownum row_id from (
select vir_id from ${tableName} where ${query}) temp_aad1) tmp_add2
)where mod(tem_add2.row_id,#{mod,jdbcType=INTEGER})=0