1。。。ifnull----------nullif
2.。。。分页:
limit 10 , 3 -----------------select * from (select row_number() over (order by id) rownum) nn where nn.rownum between 1 and 1+10limit 10 , 3
1。。。ifnull----------nullif
2.。。。分页:
limit 10 , 3 -----------------select * from (select row_number() over (order by id) rownum) nn where nn.rownum between 1 and 1+10limit 10 , 3