本文介绍了一种使用SQL进行数据查询的方法，包括如何通过LEFT JOIN和WHERE子句筛选特定区域的数据，同时展示了如何获取当前日期及30天前的日期。
select rbm1.id,rbm1.rbm_email,to_char(rbm1.out_of_office,'MM/DD/YYYY') OFFICE ,rbm2.rbm_email BACKUPEMAIL
from icod_rbms rbm1 LEFT JOIN icod_rbms rbm2 on( rbm1.backup = rbm2.id )
[color=red]where[/color] rbm1.region='AAA'
（on用来关联表之间的关系）
select rbm1.id,rbm1.rbm_email,to_char(rbm1.out_of_office,'MM/DD/YYYY') OFFICE ,rbm2.rbm_email BACKUPEMAIL
from icod_rbms rbm1 , icod_rbms rbm2 where rbm1.backup = rbm2.id (+)
and rbm1.region='AAA'
--
select to_char(sysdate, 'yyyy/mm/dd') from dual;
select sysdate from dual
--获取30天前日期
select trunc(sysdate - 30) from dual;
from icod_rbms rbm1 LEFT JOIN icod_rbms rbm2 on( rbm1.backup = rbm2.id )
[color=red]where[/color] rbm1.region='AAA'
（on用来关联表之间的关系）
select rbm1.id,rbm1.rbm_email,to_char(rbm1.out_of_office,'MM/DD/YYYY') OFFICE ,rbm2.rbm_email BACKUPEMAIL
from icod_rbms rbm1 , icod_rbms rbm2 where rbm1.backup = rbm2.id (+)
and rbm1.region='AAA'
--
select to_char(sysdate, 'yyyy/mm/dd') from dual;
select sysdate from dual
--获取30天前日期
select trunc(sysdate - 30) from dual;
扫一扫
509
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
