大概这样行不? select telnum from TelCHG where not in select telnum from TelCHG where chgTM>50天之前 and chgTM<=今天
select distinct colname,colurl,colid from v_userrights where userid not in (select roleid from tb_userrole where userid="+userid+") or userid="+userid)这是我以前项目中的..你改一下吧..
好像要加括号。。那么可不可以这样.. select telnum from TelCHG where telnum not in (select telnum from TelCHG where chgTM>50天之前 and chgTM<=今天)
select distinct telnum from TelCHG where telnum not in (select telnum from TelCHG where chgTM>sysdate-50)
用oracle的sql写了一个: select telnum,ceil(sysdate-max(chgtm)) diff_days,max(chgtm) from TelCHG a group by telnum having ceil(sysdate-max(chgtm)) >1
select telnum,ceil(sysdate-max(chgtm)) diff_days,max(chgtm) from TelCHG a group by telnum having ceil(sysdate-max(chgtm)) >50 --补充一下,替换为50
select telnum from TelCHG group by telnum having max(chgTM)<50;
select telnum(手机号) from (select telnum(手机号), max(chgTM(充值时间)) chgT from TelCHG group by telnum(手机号)) where chgT <= sysdate - 50
我写个oracle语法的:select * from TelCHG where not exists(select id from TelCHG where chgTM-SYSDATE<50)记得给分哈,谢谢了。
SELECT * FROM TELCHG GROUP BY ID HAVING MAX(chgTM)<SYSDATE-50
select distinct telnum from TelCHG where telnum not in (select telnum from TelCHG where chgTM>sysdate-50 and chgTm<sysdate) 楼主看看行不
select * from teleinfo where sid in (select max(sid) from (select * from teleinfo where datediff(dd,chgtm,getdate())>50) as s group by telnum)说明: teleinfo 表的名称
select telnum from TelCHG
where
not in
select telnum from TelCHG
where chgTM>50天之前
and chgTM<=今天
select telnum from TelCHG
where telnum
not in
(select telnum from TelCHG
where chgTM>50天之前
and chgTM<=今天)
最多选的时候加个unique避免重复。。选出在50天内冲过值的手机号 然后在所有手机号里把这部分去掉 不就是所需要求的手机号了么。。
哪里有问题呢?
select telnum,ceil(sysdate-max(chgtm)) diff_days,max(chgtm)
from TelCHG a
group by telnum
having ceil(sysdate-max(chgtm)) >1
from TelCHG a
group by telnum
having ceil(sysdate-max(chgtm)) >50 --补充一下,替换为50
group by telnum having max(chgTM)<50;
from (select telnum(手机号), max(chgTM(充值时间)) chgT
from TelCHG
group by telnum(手机号))
where chgT <= sysdate - 50
where not exists(select id from TelCHG where chgTM-SYSDATE<50)记得给分哈,谢谢了。
(select max(sid) from
(select * from teleinfo where datediff(dd,chgtm,getdate())>50) as s
group by telnum)说明:
teleinfo 表的名称