Skip to content

Instantly share code, notes, and snippets.

@tye-shutty
Last active May 29, 2019 14:05
Show Gist options
  • Save tye-shutty/7bf2035be114f7f9130e579d62fc650d to your computer and use it in GitHub Desktop.
Save tye-shutty/7bf2035be114f7f9130e579d62fc650d to your computer and use it in GitHub Desktop.
select function-a(h.b), h.c, i.e from a h inner join d i on h.f = i.g
--must use alias if given
---HOUR() function. MySQL hour() returns the HOUR of a time.
select * from agent_session where tenant_id='88624040-053f-4450-a2c6-f1e48db682ea' order by start_timestamp desc;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment