Unions in the Sample Charts

Many of the Plotalot sample charts use the SQL Union operator to return multiple rows of fixed data:

SELECT 1 AS X, 3 AS Y
UNION SELECT 2, 0
UNION SELECT 3, 3

This is just a convenient way of providing data for the sample charts without needing a sample data table. The SQL statement above returns three rows, each with two columns. Plotalot doesn't care what SQL you use, as long as it starts with a "Select".

You wouldn't normally write queries like this, but if you do, make sure to use the "AS" clause for the first row to name the columns. This query will only return one column in Plotalot, because both columns have the name '1':

SELECT 1, 1
UNION SELECT 2, 0