"We use Oracle syntax and write <column expr> <alias> instead of ANSI SQL <colum... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		datadrivenangel 5 days ago \| parent \| context \| favorite \| on: SQL Design Patterns (2010) "We use Oracle syntax and write <column expr> <alias> instead of ANSI SQL <column expr> AS <alias>. Ditto for table expressions" Footnote on page 3.

jslaby 5 days ago [–]

T-SQL can handle that alias expr just fine, but the seqNum returned is 4,8,12,16,20 instead of the 1,2,3... I tried on MySQL and it works fine. I'm not sure how SQL Server is handling those cartesian joins differently

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