Skip to content

Instantly share code, notes, and snippets.

@kaeawc

kaeawc/gist:ea40f7efc3b46ace2794

Created September 16, 2014 16:20
Show Gist options
  • Save kaeawc/ea40f7efc3b46ace2794 to your computer and use it in GitHub Desktop.
Save kaeawc/ea40f7efc3b46ace2794 to your computer and use it in GitHub Desktop.
Download ZIP
Using subqueries and aliases to create aggregations
Raw
gistfile1.txt
SELECT COUNT(a.asdf) as count_of_asdfs FROM (SELECT 2 as asdf ) as a JOIN (SELECT 3 as fdsa) as b ON b.fdsa=3 GROUP BY b.fdsa;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment