aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/distinct/distinct_groupby.sql
blob: 232a2b5a961c8171aa39bbe105611f3cba138d05 (plain) (blame)
1
2
3
4
5
6
/* syntax version 1 */

use plato;

select distinct k || "_" as k1, "_" || v as v1 from Input2 group by key as k, value as v order by k1,v1;