MrSigma

Untitled

May 9th, 2021
1,602
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT
  2.     telemetry_id
  3.     JSON_OBJECT("ScheduledQueriesList", JSON_OBJECT("n", example_telemetry.name)),
  4.     MIN(DATE),
  5.     MAX(DATE)
  6. FROM
  7.     example_telemetry
  8. GROUP BY
  9.     example_telemetry.telemetry_id[/code]
  10.  
  11. [b]Aliasing should be performed USING AS[/b]
  12. [code]SELECT
  13.     table_one.column_a AS column_one,
  14.     table_one.column_b AS column_two
  15. FROM
  16.     tableOne AS table_one
RAW Paste Data