下面这个SQL是web页面查询分页显示的一个常见用法:
select *
from (select row_.*, rownumpafa_rownum
from (select a.id_qt_wait_task_infotaskId, a.department_codedepartmentCode, insuranceEndTime,......
from qt_wait_task_info a
where 1 = 1
and a.task_state in ('B0','B1', 'B2', 'B3')
AND a.plan_code = :1
AND