简单一生，快乐一生~

昨天发现一个很奇怪的现象，我在分页时的SQL明明是6条，结果确是意想不到的（是9条），我的SQL是这样的[code="sql"]select rownum,Page.* from(select id_item,itemname,id_itemclass,id_org from stm_list where id_item not in (select id_item from stm_exppsi...

[img]D:\a.bmp[/img]如上图的一张表，我要统计operateid分别为OPER000001,OPER000002,OPER000003有多少记录且按照OPER000001，OPER000002，OPER000003的统计结果进行desc排序。代码如下：[code="sql"]select a.id_item as id_item,a.operatenum as op...