[R] SQL vs R

[David Winsemius]

On May 3, 2014, at 9:10 PM, Satish Anupindi Rao wrote:

> 
> " By making the effort to learn R?"? very constructive and not condescending at all. We, lesser beings, are indebted to you, sir.

For Pete's sake. The OP didn't even express his original request in natural language or offer a working example. Those of us who are not regular SQL users would have needed to parse out the SQL code in order to figure out what was intended. (My guess is that it would have been quite easy to solve if those were what were offered.)  But making the effort to divine the intent didn't seem justified by the level of courtesy offered by the questioner.

-- 
David.

> 
> -----Original Message-----
> From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-project.org] On Behalf Of Bert Gunter
> Sent: Saturday, May 03, 2014 1:12 AM
> To: Dr Eberhard Lisse
> Cc: r
> Subject: Re: [R] SQL vs R
> 
> By making the effort to learn R?
> 
> See e.g. the "Introduction to R" tutorial that ships with R.
> 
> -- Bert
> 
> Bert Gunter
> Genentech Nonclinical Biostatistics
> (650) 467-7374
> 
> "Data is not information. Information is not knowledge. And knowledge is certainly not wisdom."
> H. Gilbert Welch
> 
> 
> 
> 
> On Fri, May 2, 2014 at 2:23 PM, Dr Eberhard Lisse <nospam at 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")
>> 
>> greetings, el
>> 
>> ______________________________________________
>> R-help at 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.
> 
> ______________________________________________
> R-help at 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.
> 
> ______________________________________________
> R-help at 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.

David Winsemius
Alameda, CA, USA