Skip to content

Instantly share code, notes, and snippets.

@parzibyte

parzibyte/3.sql Secret

Created December 29, 2020 02:57
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 parzibyte/73af02ffbeb0ff4b1dfc565513d9a96e to your computer and use it in GitHub Desktop.
Save parzibyte/73af02ffbeb0ff4b1dfc565513d9a96e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
3.sql
# Mostrar la fecha en la que se registró la mínima temperatura, y también mostrar la fecha en la que se registró la máxima
SELECT date
FROM dht_log
ORDER BY temperature ASC
LIMIT 1;
SELECT date
FROM dht_log
ORDER BY temperature DESC
LIMIT 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment