2 ms·
> 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
by marcosdumay 3y ago
> 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