Using SQL-like Queries with sqldf: Subsetting Data Frames in R

Passing Variables to SQL Statements with sqldf in R

Combining Row Names in Extensive Dataframes While Keeping Data Associated with Specific Rows Using ddply and summarise

Optimizing SQL-like Operator Searches with Dictionary Lookups

Alternative Methods for Efficient Data Analysis: tapply(), acast() and Beyond