日期:2014-05-18 浏览次数:20589 次
select COUNT(distinct c-ip) from 表A where sc-status=200 and cs(Referer) like '%.html' or cs(Referer) like '%.htm'
select COUNT(distinct c-ip) from 表A where sc-status=200 and ([cs(Referer)] like '%.html' or [cs(Referer)] like '%.htm')
------解决方案--------------------
select COUNT(distinct c-ip) from 表A where (sc-status=200 or sc-status=60) and ([cs(Referer)] like '%.html' or [cs(Referer)] like '%.htm') --or select COUNT(distinct c-ip) from 表A where sc-status in (200,60) and ([cs(Referer)] like '%.html' or [cs(Referer)] like '%.htm')
------解决方案--------------------
select COUNT(distinct c-ip) from 表A where sc-status in (200,60) and ([cs(Referer)] like '%.html' or [cs(Referer)] like '%.htm'