Skip to content

Instantly share code, notes, and snippets.

@ofelix03

ofelix03/readable-query-without-lateral.sql

Last active November 4, 2022 13:09
Show Gist options
  • Save ofelix03/294f89e8071b24ca390474cb9de0cadb to your computer and use it in GitHub Desktop.
Save ofelix03/294f89e8071b24ca390474cb9de0cadb to your computer and use it in GitHub Desktop.
Download ZIP
Raw
readable-query-without-lateral.sql
select *, (
select concat(date, ' ', time) "last_visited" from site_visits
where user_id = u.id
order by id desc
limit 1
) "last_visited"
from users u
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment