distinct_union_all.sql 172 B

123456789
  1. /* syntax version 1 */
  2. use plato;
  3. pragma AnsiOrderByLimitInUnionAll;
  4. select distinct key, value from Input2
  5. union all
  6. select key, value from Input2 order by key, value;