常用的查询语句

select * from zlk_infromain ,zlk_poisoninf where zlk_infromain.inforegdate between to_date('2005-06-01','yyyy-mm-dd') and to_date('2005-07-01','yyyy-mm-dd')
and  (contains(zlk_poisoninf.treatment,'þ')>0);
--------------------------------------------
select * from cdc_reportcard t  where baddate=to_date('2005-7-3','yyyy-mm-dd') and disid=182
---------------------------------------------
select * from cdc_reportcard t where  months_between(BADDATE,BIRTHDATE)>=0 and months_between(BADDATE,BIRTHDATE)<12 and baddate between to_date('2005-01-01','yyyy-mm-dd') and to_date('2005-03-31','yyyy-mm-dd')
--------------------------------------------
select count(*),to_char(baddate,'yyyy-mm') from cdc_reportcard t group by to_char(baddate,'yyyy-mm')
----------------------------------------------
select * from zlk_poisoninf t where contains (summarize,’中毒’) >1
---------------------------------------------
select * from zlk_poisoninf t where summarize  like '%%中毒%%'
------------------------------------------
select * from zlk_poisoninf t where summarize  like '%%中毒%%' or  contains(diagnose,'鼠')>1
----------------------------------------------
select * from cdc_reportcard t where disid=&disid order by cardid

-------------------------------------------------
select * from cdc_reportcard t where  deletedate is  null