Skip to content

Instantly share code, notes, and snippets.

@bryanyang0528

bryanyang0528/gist:3430d7ea17a917689f6a

Created July 9, 2014 10:37
Show Gist options
  • Save bryanyang0528/3430d7ea17a917689f6a to your computer and use it in GitHub Desktop.
Save bryanyang0528/3430d7ea17a917689f6a to your computer and use it in GitHub Desktop.
Download ZIP
SQLDF EXAMPLE1
Raw
gistfile1.r
library("sqldf")
x <- sqldf("
SELECT gender, age, sum(icome)
FROM client
GROUP BY gender, age
ORDER BY gender, age
")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment