I am using sqldf package to run query on mtcars dataset, but I am facing issue fetching car names. Please find the query below :
sqldf("select * from df limit 10")
Now, above query does not fetch me car names as output as it does not have column name.
Please let me know how to fetch car name using only sqldf query not indexing.
Thanks in advance.