复制
收藏
提问
全网
2个月前
SELECT b.dbbarq as year, a.id,a.bjbh,a.bdh,a.xmmc FROM "MH-JSGCZTB".biz_tender_base AS a LEFT JOIN "MH-JSGCZTB".biz_tender_smbg AS b ON a.id=b.tender_id WHERE a.status='1' AND b.sfwcdbba='1' and b.dbbarq >= ADD_MONTHS(SYSDATE, -12) AND b.dbbarq IS NOT NULL 这段sql为什么可检索出25年的数据
理解问题SELECT b.dbbarq as year, a.id,a.bjbh,a.bdh,a.xmmc FROM "MH-JSGCZTB".biz_tender_base AS a LEFT JOIN "MH-JSGCZTB".biz_tender_smbg AS b ON a.id=b.tender_id WHERE a.status='1' AND b.sfwcdbba='1' and b.dbbarq >= ADD_MONTHS(SYSDATE, -12) AND b.dbbarq IS NOT NULL 这段sql为什么可检索出25年的数据
已完成理解「SELECT b.dbbarq as year, a.id,a.bjbh,a.bdh,a.xmmc FROM "MH-JSGCZTB".biz_tender_base AS a LEFT JOIN "MH-JSGCZTB".biz_tender_smbg AS b ON a.id=b.tender_id WHERE a.status='1' AND b.sfwcdbba='1' and b.dbbarq >= ADD_MONTHS(SYSDATE, -12) AND b.dbbarq IS NOT NULL 这段sql为什么可检索出25年的数据」
展开阅读网页
更专业一些 
转笔记
专业
SELECT b.dbbarq as year,
a.id,a.bjbh,a.bdh,a.xmmc
FROM "MH-JSGCZTB".biz_tender_base AS a
LEFT JOIN "MH-JSGCZTB".biz_tender_smbg AS b ON a.id=b.tender_id
WHERE a.status='1' AND b.sfwcdbba='1'
and b.dbbarq >= ADD_MONTHS(SYSDATE, -12)
AND b.dbbarq IS NOT NULL 这段sql为什么可检索出25年的数据不在提醒