Skip to content

Instantly share code, notes, and snippets.

@gdoddsy

gdoddsy/AggregateFunctionsinanUpdateStatementquery2.sql

Last active November 11, 2018 19:02
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save gdoddsy/ab13f4f59a099e36f0712cf3eef87e73 to your computer and use it in GitHub Desktop.
Save gdoddsy/ab13f4f59a099e36f0712cf3eef87e73 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
AggregateFunctionsinanUpdateStatementquery2.sql
INSERT INTO AggregateTest (Gate, LastUsedDateTime)
SELECT Gate
MAX(RecordedTime)
FROM SFOGateInfo
GROUP BY Gate
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment