SQL queries don't start with SELECT

Re:SQL queries don't start with SELECT by perl4ever on Thursday October 03, 2019 @05:53PM (#21152642)

My SQL queries generally start with WITH.

Or they did when I was using Oracle.

[ Parent | on HN ]

Re:SQL queries don't start with SELECT by scomp on Thursday October 03, 2019 @06:37PM (#21152997)

To be honest I don't think the article highlights very well where this applies. I am a SQL Developer with SQL Server right now and in the past using Teradata I vaguely remember an aliased column could be referenced in the where clause if you didn't use the AS keyword.

[ Parent | on HN ]