This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
@chmurray88 I have used nested CTEs and I am still able to get the output results fields
with inner_cte as (
select * from
“all_data_types” where c_int <= 1000 limit 100)
,
outer_cte as
(select * from
inner_cte where c_int is not null limit 100
)
sel...
Hi @chmurray88 To reply your question , yes Postgres Execute snap supports CTEs as part of a query. I took 2 CTEs and did a sample left join (both CTE is referring to same table with diff filter criteria) and the output result is as expected
My SQL s...
