Telemetry/LongitudinalExamples: Difference between revisions

m
→‎Arrays: use subscript operator
(→‎Maps: add maps example)
m (→‎Arrays: use subscript operator)
Line 12: Line 12:
=== Arrays ===
=== Arrays ===
Other properties are arrays, which contain one entry for each submission from that client (newest first):
Other properties are arrays, which contain one entry for each submission from that client (newest first):
  SELECT element_at(reason, 1) AS last_reason
  SELECT reason[1] AS newest_reason
  FROM longitudinal_v20160229
  FROM longitudinal_v20160229
  WHERE os = 'Linux'
  WHERE os = 'Linux'
Confirmed users
95

edits