Imagine a table contains a multi-column report which is read in batches of 64 records with the first row being a record having the same number of columns coming from another table.
I tried the following SQL; for simplicity, I am using the first row comes from the same table.
<code>
SELECT *
FROM sales limit 1 offset 0
UNION
SELECT *
FROM sales limit 64 offset 1;
</code>
returns
> Error: LIMIT clause should come after UNION NOT before
- Is the error referring to the statement above UNION or to the one below?
- Looking for a quick way to refactor my SQL. Ideas?