常用的查询语句_cdc话语-优快云博客

博客展示了多条数据库SQL查询语句，涉及不同表的查询操作，包括按日期范围筛选、条件筛选、统计计数、分组查询等，如对zlk_infromain、zlk_poisoninf、cdc_reportcard等表的查询。

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