Modern R Programming Cookbook

There's more...

Once you have a database and the data is stored in it, you can easily interact with it. The full range of SQL statements can be used using the dbGetQuery() function. The only thing you have to be careful of is the name of the table and the name of variables. You should use double quotations for both the table name and variable names. Moreover, the entire SQL statement should be enclosed with single quotations.