Subquery returns null in SQL February 9, 2021 select 1 as x, (select 1 limit 0) as y; x | y ---+--- 1 | null