by 동물칭구칭구 [SQL Query] POSTGRELSQL QUERY [2019.02.13 17:35:55]
.,펑.,펑.,펑.,펑.,펑.,펑.,펑.,펑.,펑
SELECT schema_nm, tb_nm FROM t GROUP BY schema_nm, tb_nm HAVING COUNT(CASE WHEN partitionname = 'p201902' THEN 1 END) = 0 ;