Useful SQL

Crafty way to create a temporary table (view) with some rows in it:

CREATE VIEW Xyz AS
    SELECT 'A' AS id
UNION ALL
    SELECT 'B' AS id
UNION ALL
    SELECT 'C' AS id
UNION ALL
    SELECT 'D' AS id;

Creates a table:

Xyz

id

A

B

C

D