select count(*)--callid,callidnum endno,callerno,calleeno,waitbegin,callend,preserviceno presno,serviceno, calltype,devicetype dt,predeviceno predno,predevicein predin
from tbilllog7
where CALLEND >= to_date('20100702000000','YYYYMMDDHH24MISS')
and
CALLEND < to_date('20100703000000','YYYYMMDDHH24MISS')
and
CALLTYPE in (0,5,13)
and
devicetype!=3 --(devicetype = 2 or (devicetype = 1 and callidnum = -1))
and
(SERVICENO=51 or SERVICENO=70)
and
(CALLEENO='83509094' or CALLEENO='83500198')
--order by waitbegin asc --(CALLEENO='83509094' or CALLEENO='83500198' or CALLEENO='83508121' or CALLEENO='83500081' or CALLEENO='86303030')
;
select *--callid,callidnum endno,callerno,calleeno,waitbegin,callend,preserviceno presno,serviceno, calltype,devicetype dt,predeviceno predno,predevicein predin
from tbilllog7
where CALLEND >= to_date('20100702000000','YYYYMMDDHH24MISS')
and
CALLEND < to_date('20100703000000','YYYYMMDDHH24MISS')
and
CALLTYPE in (0,5,13)
and
devicetype!=3 --(devicetype = 2 or (devicetype = 1 and callidnum = -1))
and
(SERVICENO=51 or SERVICENO=70)
and
(CALLEENO='83509094' or CALLEENO='83500198')
--order by waitbegin asc --(CALLEENO='83509094' or CALLEENO='83500198' or CALLEENO='83508121' or CALLEENO='83500081' or CALLEENO='86303030')
;
为何上面count是300多,但是*列出的结果才33条?~
求教~谢谢!!!
from tbilllog7
where CALLEND >= to_date('20100702000000','YYYYMMDDHH24MISS')
and
CALLEND < to_date('20100703000000','YYYYMMDDHH24MISS')
and
CALLTYPE in (0,5,13)
and
devicetype!=3 --(devicetype = 2 or (devicetype = 1 and callidnum = -1))
and
(SERVICENO=51 or SERVICENO=70)
and
(CALLEENO='83509094' or CALLEENO='83500198')
--order by waitbegin asc --(CALLEENO='83509094' or CALLEENO='83500198' or CALLEENO='83508121' or CALLEENO='83500081' or CALLEENO='86303030')
;
select *--callid,callidnum endno,callerno,calleeno,waitbegin,callend,preserviceno presno,serviceno, calltype,devicetype dt,predeviceno predno,predevicein predin
from tbilllog7
where CALLEND >= to_date('20100702000000','YYYYMMDDHH24MISS')
and
CALLEND < to_date('20100703000000','YYYYMMDDHH24MISS')
and
CALLTYPE in (0,5,13)
and
devicetype!=3 --(devicetype = 2 or (devicetype = 1 and callidnum = -1))
and
(SERVICENO=51 or SERVICENO=70)
and
(CALLEENO='83509094' or CALLEENO='83500198')
--order by waitbegin asc --(CALLEENO='83509094' or CALLEENO='83500198' or CALLEENO='83508121' or CALLEENO='83500081' or CALLEENO='86303030')
;
为何上面count是300多,但是*列出的结果才33条?~
求教~谢谢!!!
兄弟 你是在哪运行的 在sqlplus是不会有这样的问题 要是在plsql 的话 你的在结果集显示的地方的工具栏有个显示下页的记录
楼主貌似也是呼叫中心的。 仔细检查一下. 在sqlplus里把执行过程贴出来看一下..
PL/SQL工具的话,是绿色的双向下箭头,
现在好了,两绿色倒三角倒出了所有数据,……谢谢各位方家:)