yql/essentials/tests/sql/suites/distinct/distinct_union_all.sql


1
2
3
4
5
6
7
8
9

/* syntax version 1 */

use plato;
pragma AnsiOrderByLimitInUnionAll;

select distinct key, value from Input2
union all
select key, value from Input2 order by key, value;