Try out SQLite FROM before SELECT in SQLite

by willvarfar • 2 years ago

3 1 2 years ago

willvarfar• 2 years ago

Here's an example snippet you can try out in the fiddle:

    WITH x AS (
      SELECT 1 AS foo
      UNION ALL
      SELECT 2 AS foo
    )

    FROM x
    SELECT *
    WHERE foo > 1

Related Stories