Skip to content

Instantly share code, notes, and snippets.

@etobi
Created October 1, 2015 16:16
Show Gist options
  • Save etobi/01bc825e1499ccc49e02 to your computer and use it in GitHub Desktop.
Save etobi/01bc825e1499ccc49e02 to your computer and use it in GitHub Desktop.
SELECT
(SELECT sum(value) FROM kata1 WHERE type = 'a') as sum_a,
(SELECT sum(value) FROM kata1 WHERE type = 'b') as sum_b
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment