Skip to content
Advertisement

Tag: amazon-redshift

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