Skip to content

Instantly share code, notes, and snippets.

@3YH

3YH/alternative_query_test

Created May 4, 2020 16:55
Show Gist options
  • Save 3YH/1c35858546f9a7944eb4f63b948a2b9d to your computer and use it in GitHub Desktop.
Save 3YH/1c35858546f9a7944eb4f63b948a2b9d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
alternative_query_test
SELECT t1.status_code, t1.response_time, t1.monitor_status, t1.performed_at FROM uptime_checks AS t1 WHERE performed_at = (SELECT max(t2.performed_at) FROM uptime_checks as t2 WHERE t1.monitor_id = t2.monitor_id);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment