SQLite Forum

When is SELECT ... FROM with no table-or-subquery valid.
Login
> I sincerely hope NOT. It has been perfectly legal (right up to release 3.24) to do 
>
>SELECT 1,datetime(...),trim(...);

There is no FROM there. This thread is about SELECT ... FROM without a table or subquery.