On Fri, May 2, 2014 at 5:23 PM, Dr Eberhard Lisse <nos...@lisse.na> wrote: > Hi, > > How do I do something like this without using sqldf? > > a <- sqldf("SELECT COUNT(*) FROM b WHERE c = 'd'") > > or > > e <- sqldf("SELECT f, COUNT(*) FROM b GROUP BY f ORDER BY f") >
In the examples section at the bottom of ?sqldf are a number of SQL statements and the corresponding R statements. -- Statistics & Software Consulting GKX Group, GKX Associates Inc. tel: 1-877-GKX-GROUP email: ggrothendieck at gmail.com ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.