yql-8041-fuse_with_desc_map.sql 241 B

1234567891011121314151617
  1. /* postgres can not */
  2. USE plato;
  3. $i = (
  4. SELECT
  5. cast(key as Double) as key,
  6. value
  7. FROM Input
  8. WHERE key < "100"
  9. ORDER BY key DESC
  10. LIMIT 1000
  11. );
  12. select distinct key
  13. from $i
  14. where value != ""
  15. order by key;