常见sql

select t.id ,t.gdtype,t.tsfrom, '1' as type from COMPLAINTS t where t.tsfrom='QQ'
union 
select t.id ,t.gdtype,t.tsfrom, '2' as type from COMPLAINTS t where t.tsfrom='QQ';


SELECT distinct new CustomManage(cpdescribe) FROM CustomManage C WHERE C.cpdescribe IS NOT NULL 


select * from cpdescribe  from CUSTOMMANAGE c where  c.cpdescribe is not null ;
select * from comp_disposal;
select * from complaints_assign;


select * from COMP_DISPOSAL c;


select count(M.Contact) from COMPLAINTS M where M.Contact = '符丽娟'


select * from MEMBER_INFOS m where m.xm='符丽娟';


select * from MEMBER_INFOS c where c.;


select * from COMPLAINTS for update


select count(c.contact) from COMPLAINTS c where c.contact='符丽娟'


select * from COMP_DISPOSAL for  update ;


select
        distinct custommana0_.khname as col_0_0_ 
    from
        custommanage custommana0_ 
    where
        custommana0_.khname is not null
        201381002
select *from Complaints c ,COMP_DISPOSAL s where c.gdid = s.gdid


select count(*) from Complaints c ,COMP_DISPOSAL s where c.gdid = s.gdid


select * from COMPLAINTS c


select MAX(c.gdid) from  COMPLAINTS c


select TO_CHAR(SYSDATE(),'YY/MM/DD HH24:MI:SS);
select to_char(sysdate,'yy-mm-dd hh24:mi:ss') from dual  


select gdid from Complaints c where c.GDTIME like to_date('2013-7-22','yyyy-mm-dd') order by c.ID


select
        complaints0_.gdid as col_0_0_ 
    from
        complaints complaints0_ 
    where
        complaints0_.gdtime like to_date('2013-07-22','yyyy-mm-dd') 
    order by
        complaints0_.id desc
        
   select * from Complaints


select s.hyzcm from MEMBER_INFOS s;


select * from COMPLAINTS for update;---对表的数据进行编辑


select C.CPNAME from CUSTOMMANAGE C WHERE C.CPNAME IS NOT NULL GROUP BY C.CPNAME;


select distinct c.cpname from CUSTOMMANAGE C WHERE C.CPNAME IS NOT NULL;


select c.contact,c.telphonenum from COMPLAINTS C where c.hyid = '15645874587'


SELECT C.CPNAME FROM CustomManage C WHERE C.cpname IS NOT NULL GROUP BY cpname


select c.cpdescribe from CUSTOMMANAGE c where c.cpname is not null and C.cpname='酒店' order by cpdescribe DESC;


select * from company t where t.name = '张三';


select cpdescribe from CustomManage c where c.cpname is not null and c.cpname='MSN'


TRUNCATE TABLE COMPLAINTS ;








select * from COMPLAINTS e ,COMP_DISPOSAL c where e.GDID = c.GDID;


select * from COMPLAINTS for update
update COMPLAINTS t set t.REPLYTIME = '2013-08-05'


select * from t_users r where r.name=''; 


update COMPLAINTS c set c.cjrid =


select * from comp_disposal


commit;


select * from  COMPLAINTS c for update where c.id=10025;


select * from COMP_DISPOSAL for update;
  


select c.DEAL_STATUS  from COMP_DISPOSAL c where GDID=2013723002






select * from Company;


truncate table COMPLAINTS ;
select * from MEMBER_INFOS
select t.id  from CUSTOMMANAGE t where t.id = 10012


update CUSTOMMANAGE t set CUSTOMMANAGE.Cpname = '' where t.id=10025;


update COMPLAINTS t set t.PRODUCTTYPE = 10010 where t.id=10010;






update COMPLAINTS t set t.PRODUCTTYPE = 10010 where t.id=10010;


update COMPLAINTS t set t.PRODUCTTYPE = 10010 where t.id=10010;




update COMPLAINTS t set t.PRODUCTTYPE = 10010 where t.id=10010;


update COMPLAINTS t set t.PRODUCTTYPE = 10010 where t.id=10010;




select * from CUSTOMMANAGE t where t.khname is not null;
select *from member_infos t where t.hyzcm='tp10000805'


select * from COMPLAINTS for update;


select * from comp_disposal


BURDEN_ASSOCIATE






select * from 
















select* from COMPLAINTS for update


===insert into B(字段名)(select 字段名 from A) 




insert  into COMPLAINTS(ISCONCLUDED)(select ss.DIFF_LEVEL from  COMP_DISPOSAL ss,COMPLAINTS s where s.GDID = ss.GDID and ss.DIFF_LEVEL is not nul);








select * from COMP_TURN_CONFIG t where t.GDID = '2013829003'






select
        compturnco0_.id as id40_,
        compturnco0_.deal_dept as deal2_40_,
        compturnco0_.deal_person as deal3_40_,
        compturnco0_.deal_status as deal4_40_,
        compturnco0_.end_tache as end5_40_,
        compturnco0_.end_time as end6_40_,
        compturnco0_.gdid as gdid40_,
        compturnco0_.open as open40_,
        compturnco0_.operate_time as operate9_40_,
        compturnco0_.operator as operator40_,
        compturnco0_.postil as postil40_,
        compturnco0_.remind as remind40_,
        compturnco0_.send as send40_,
        compturnco0_.send2 as send14_40_,
        compturnco0_.start_tache as start15_40_,
        compturnco0_.start_time as start16_40_,
        compturnco0_.state as state40_,
        compturnco0_.tache as tache40_,
        compturnco0_.timelimit as timelimit40_,
        compturnco0_.type as type40_ 
    from
        comp_turn_config compturnco0_ 
    where
        compturnco0_.gdid='2013829006'










select * from COMP_DISPOSAL a where a.DEAL_INFO = '处理完毕'


SELECT * FROM COMP_DISPOSAL WHERE DBMS_LOB.INSTR(comp_disposal.DEAL_INFO,'处理完毕',1,1)>0;


select * from COMP_TURN_CONFIG where gdid = '2013828102'


select * from COMP_APPROVE_OPINION t where t.GDID = '2013829006'
select * from COMP_TURN_CONFIG t where t.GDID = '2013829002'






select * from COMPLAINTS w where w.gdid = '201396001'.




select * from COMPANY C where C.lxrdh='15889614442' and C.ssgj=''