Hi,
I used following SQL query to fetch information from DB
> dbGetQuery(Conn, "select ID from XXXX where date = '2018-07-18' and ID =
'72075186224672770' limit 10")
ID
1 72075186224672768
As you see, it is returning a different result from what actual query
string contains.
However when I used the same query in some other SQL client, I get the
expected result as:
72075186224672770
Any idea on what went wrong in R supplied query would be highly appreciated.
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
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.
