操作的用的sql语句

--查询总共有多少人订阅
    select distinct usernumber from usertailor 

--查询分类订阅用户
    select count(usernumber) service from usertailor group by service

--查mT信息
select count(msglength) from sms.curmissionct    where msgcontent like '一个人好孤单%'

select count(msglength) from sms.curmissionct    where createtime>TO_DATE('2006-02-21 17:00:00','YYYY-MM-DD HH24:MI:SS')

select count(msglength) from sms.curmissionct    where usernumber like '0919%'  and createtime>TO_DATE('2006-02-22 15:00:00','YYYY-MM-DD HH24:MI:SS')

select count(msglength) from sms.curmissionct    where msgcontent like '老夫妇去拍照%'  and createtime>TO_DATE('2006-02-24 16:00:00','YYYY-MM-DD HH24:MI:SS')

--查询收到多少MO
   select count(unique usernumber) from sms.curuserorderct where msgtime>TO_DATE('2006-02-24 16:00:00','YYYY-MM-DD HH24:MI:SS')

--查询有多少人订阅
   select  distinct usernumber from usertailor  where createtime>to_date('2006-02-24 16:00:13',' yyyy-mm-dd hh24:mi:ss')

--查询某人是否订阅
   select usernumber from  game.usertailor where  usernumber='09123316172'

--查询某个服务有多少人订阅  
   select  usernumber from usertailor  where service='13'

   select distinct usernumber from usertailor a,usertailor b where a.usernumber=b.usernumber and a.service<>b.service
--删除业务表内容

  delete from game.tailor_xiaohua where seq<150;

--发了mo 但没确认订阅的
  select unique usernumber from sms.curuserorderct where msgtime>TO_DATE('2006-02-14 20:00:00','YYYY-MM-DD HH24:MI:SS')
               and  usernumber not in(select unique usernumber from usertailor);

--查询某人是否订阅

   select usernumber from  game.usertailor where  usernumber='09196781509'

--查询退订的人
   select distinct usernumber from sms.curuserorderct where msgcontent like 'QX%' 
 
   select distinct usernumber from sms.curuserorderct where msgcontent like 'QX%'
                              and msgtime>TO_DATE('2006-02-21 17:00:00','YYYY-MM-DD HH24:MI:SS')
                              and sms.curuserorderct where msgcontent

---------------------------------