yql-14538.sql 220 B

123456789101112131415161718
  1. use plato;
  2. INSERT INTO Output
  3. SELECT
  4. key as key,
  5. "" as subkey,
  6. "value:" || value as value
  7. FROM Input
  8. WHERE key < "100"
  9. ORDER BY key
  10. LIMIT 5;
  11. INSERT INTO Output
  12. SELECT
  13. *
  14. FROM Input
  15. ORDER BY key
  16. LIMIT 4;