60 second software development tutorials and demos, and short blog posts.

SELECT directly from values

If you want to select multiple sets of values with no tables involved, you can do:

SELECT * FROM (
    VALUES (1, 2), (3, 4)
) X(a, b);