Tag: rsqlite

Syntax error in SQL code being used in R, no row_number function found

I am using RSQLite, DBI, and dbplyr packages. I’m watching this YouTube video by TechTFQ. I’m getting a syntax error with this line. Error: near “row_number”: syntax error I’m certain that the SQL syntax I’m writing here is the same as what I’m watching in the YouTube video, except for the differences in the dataframe that I’m using and the

R using RSQLite, DBI and dbplyr, can’t have more than one table in the RSQLite in order to make a join

dbi dbplyr r rsqlite sql

I’m having a hard time understanding the behavior of these three packages: RSQLite, DBI, and dbplyr. I’m using the mtcars dataframe and I’m loading it with the tibble package to add the car name as one of the rows. I also created my own table that has information about where all these cars were built: By creating these two tables