pg数据库EXISTS用法

pg数据库EXISTS用法

	WITH LatestSubmit AS (
    SELECT MAX(SubmitTime) AS MaxSubmitTime
    FROM BAReportDataState
    WHERE ReportID = '8ea9347e-16ce-4456-ab42-c1bfeb4c3037'
    AND BusPeriod = '03'
    AND YEAR = '2025'
		 
)
SELECT 
    ROUND(YYYZSRDYJE/10000, 2) AS 营业总收入
FROM BARCBB102FI01 b
WHERE EXISTS (
    SELECT 1
    FROM BAReportDataState a
    WHERE a.ReportID = '8ea9347e-16ce-4456-ab42-c1bfeb4c3037'
    AND a.BusPeriod = '03'
    AND a.YEAR = '2025'
    AND a.State = 3
    AND a.SubmitTime = (SELECT MaxSubmitTime FROM LatestSubmit)
)
AND b.data_nd = '2025'  
AND b.data_qj = '03'
AND b.data_dwid = '28163050-17da-4040-8545-63a234233f69'

用exists,只返回是不是有值，不返回结果，并当true false判断条件