Skip to content

Instantly share code, notes, and snippets.

@toyeiei
Last active Feb 5, 2019
Embed
What would you like to do?
# filter only cars with hp <= 100
sqldf("SELECT * FROM mtcars WHERE hp <= 100;")
# filter more than one conditions with AND
sqldf("SELECT * FROM mtcars WHERE hp <= 100 AND am = 1;")
# filter more than one condition with OR
sqldf("SELECT * FROM mtcars WHERE hp <= 100 OR gear = 4;")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment