yql-17413-topsort.sql 260 B

12345678910
  1. -- ignore runonopt plan diff
  2. USE plato;
  3. $filtered = select * from Input where value != "xxx";
  4. select distinct(subkey) as subkey
  5. from (select * from $filtered order by key desc limit 3)
  6. order by subkey;
  7. select sum(cast(subkey as int32)) as c from $filtered;