Skip to content
Advertisement

Tag: amazon-redshift

Redshift Rounding Off Issue

I have a table which has a numeric(23,2) field that I need to divide to a constant. My baseline is this aggregation select site, sum(sales) / 1.07 as sales from sales group by site; But when I add …

Amazon Redshift – lateral column alias reference

Based on Amazon Redshift announces support for lateral column alias reference: The support for lateral column alias reference enables you to write queries without repeating the same expressions in the SELECT list. For example, you can define the alias ‘probability’ and use it within the same select statement: Which is basically the same as: db<>fiddle demo Most SQL RDBMSes will

Advertisement