News for hackers. Stuff that matters.
Re:Shouldn't FROM come before SELECT in SQL? (2011) by marcosdumay on Thursday January 25, 2024 @09:39AM (#39130015)
> Except maybe cases where there is no data source: SELECT 1; or SELECT NOW();

I don't think the standard SQL allows those. Even though I do personally prefer this form to the standard one.

Anyway, if we are serious about maintaining SQLness, it would be something like:

SELECT FROM people COLUMNS id, name

And that reduced form would become SELECT COLUMNS 1

There are no comments on this comment yet.