Redshift: Default to zero for fields if no-match in subquery
Is there any way to default the field values from a subquery aggregate function to zero when no results are returned when using a * rather than naming the fields and using NVL or COALESCE?
Custom date range in SQL
I am trying to add a date range to my sql query.
The date range should change every quarter
Example on April 1 2024 – The date range for the data should be trailing 12 months, ie it should look at 01 April 2023 to 30 March 2024 data.
Redshift Rewriting View Creation Logic
I have created a view in Redshift using the following query: