Skip to content

Instantly share code, notes, and snippets.

@FatihGoktas

FatihGoktas/left join with group by and limit

Last active January 31, 2020 11:57
Show Gist options
  • Save FatihGoktas/0a9dae309b56ad5f97ef903b206622ad to your computer and use it in GitHub Desktop.
Save FatihGoktas/0a9dae309b56ad5f97ef903b206622ad to your computer and use it in GitHub Desktop.
Download ZIP
Raw
left join with group by and limit
SELECT
jl.*, jg.*
FROM
job.job_list AS jl
LEFT JOIN (
SELECT
*
FROM
job.job_log
ORDER BY id DESC
LIMIT 1
) AS jg ON (jg.job_id = jl.id);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment