3 ms·

Yes, it should. 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;

by x2bool 3y ago

Yes, it should. 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();

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