My SQL queries generally start with *WITH*. Or they did when I was using Oracle. | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

perl4ever on Oct 3, 2019 | parent | context | favorite | on: SQL queries don't start with SELECT

My SQL queries generally start with WITH.

Or they did when I was using Oracle.

scomp on Oct 3, 2019 [–]

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.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact