News for hackers. Stuff that matters.

A comment on SQL is 43 years old – Here’s why we still use it today. Parent comment

Re:SQL is 43 years old – Here’s why we still use it today by combatentropy on Wednesday May 03, 2017 @02:56AM (#14253591) 

  > for some reason the table comes after its fields
I agree it would have been better to start with the FROM clause and have the fields listed near the end.

  > I write in this style anyway,
  > using a chain of WITH clauses
That sounds like it could make it better. I will try that more often.

  > the ORDER BY can't be expressed using field aliases
  > defined at the start of the query
In Postgres you can!
[ Parent | on HN ]

There are no comments on this comment yet.