oracle sql

sql判断是否为空的查询语句：
select t.term from call t where class is null;

select t.term from call t where class is not null;

select mobile,visttime from local_vistlog where url like 'http://wap0579.cn/wap/hd/yd/4.jsp%' and  visttime between to_date('2011-04-22','YYYY-MM-DD') and  to_date('2011-04-23','YYYY-MM-DD')

select mobile,createtime from hd_sjyd where createtime between to_date('2010-12-20','YYYY-MM-DD')and to_date('2010-12-21','YYYY-MM-DD') order by id asc

select to_char(visttime,'HH24'),count(0),count(distinct(mobile)) from local_vistlog where visttime between to_date('2011-03-01','yyyy-MM-dd') and to_date('2011-03-31','yyyy-MM-dd') group by to_char(visttime,'HH24')

select mobile,to_char(createtime,'yyyy-MM-dd hh24:mi:ss') from hd_lovemusic where mobile is not null and to_char(createtime,'yyyy-MM-dd') between '2011-04-01' and '2011-04-07' order by createtime desc

select mobile,visttime,url from local_vistlog t where length(mobile)>0 and url ='http://wap0579.cn/wap/hd/yd/1.jsp' and visttime between to_date('2011-04-21','YYYY-MM-DD') and  to_date('2011-04-22','YYYY-MM-DD')

select mobile,createtime from hd_jcyw where kt=0 and type=2 and createtime between to_date('2010-11-01','YYYY-MM-DD') and to_date('2010-11-11','YYYY-MM-DD')

select mobile,createtime from HD_baoming where type=1 and to_char(createtime,'yyyy-MM-dd') ='2010-12-20'  order by createtime desc

转载于:https://www.cnblogs.com/varyall/archive/2011/04/22/2024815.html