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);
ab
12
34

Leave a Reply

Your email address will not be published.