syscolumns.sql 378 B

123456789101112131415
  1. /* syntax version 1 */
  2. /* postgres can not */
  3. use plato;
  4. select
  5. value,
  6. max(value) over (partition by cast(TableName() as Utf8)),
  7. cast(TableName() as Utf8),
  8. from Input order by value;
  9. select
  10. value,
  11. max(value) over (order by cast(TableName() as Utf8) rows between unbounded preceding and unbounded following),
  12. cast(TableName() as Utf8),
  13. from Input order by value;