distinct_on_multi_projection.sql 136 B

123456
  1. --!syntax_pg
  2. select 10 as u,20 as v
  3. union all
  4. select distinct on (x) x,y
  5. from (values (1,1),(1,2),(2,5),(2,4)) a(x,y)
  6. order by u,v desc