CODEWITHSUNDEEP
sqlrsqldf
Ajay Ohri
Ajay Ohri

Reputation: 3492

How do I do a subquery using sqldf in r

How do i do a subquery using sqldf in r

library(sqldf)
data(mtcars)

sqldf("select * from mtcars where mpg>avg(mpg)")

Upvotes: 1

Views: 2401

Answers (1)

Gurwinder Singh
Gurwinder Singh

Reputation: 39457

As standard SQL, you want a subquery like this:

library(sqldf)
sqldf("select *
       from mtcars
       where mpg > (
         select avg(mpg)
         from mtcars
       )"
)

Upvotes: 3

Related Questions