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
Before you know what you can SELECT you should know FROM where does the data come.
Except maybe cases where there is no data source: SELECT 1; or SELECT NOW();