Skip to content

Instantly share code, notes, and snippets.

@YumaInaura
Created December 1, 2015 03:55
Show Gist options
  • Select an option

  • Save YumaInaura/3da250d3d3693dd7f418 to your computer and use it in GitHub Desktop.

Select an option

Save YumaInaura/3da250d3d3693dd7f418 to your computer and use it in GitHub Desktop.
SQL | GROUP BY と WHERE の順番 ref: http://qiita.com/Yinaura/items/a69b4fd41a9b20b8f4ae
SELECT id
FROM user
WHERE name = 'John'
GROUP BY id
SELECT id
FROM user
GROUP BY id
WHERE name = 'John'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment