大神求救阿
小弟在R 弄了一笔资料想放到SQL上运算 在 over partition by一直出錯 但是不知道问题出在哪


以下是我的程式码

Lines <- "Group_A Group_B Group_C Value
A1 B1 C1 10
A1 B1 C2 20
A1 B1 C3 30
A1 B2 C1 40
A1 B2 C2 10
A1 B2 C3 5
A1 B2 C4 30
A2 B1 C1 40
A2 B1 C2 5
A2 B1 C3 2
A2 B2 C1 26
A2 B2 C2 1
A2 B3 C1 23
A2 B3 C2 15
A2 B3 C3 12
A3 B3 C4 23
A3 B3 C5 23"

DF <- read.table(textConnection(Lines), header = TRUE, as.is = TRUE)
library(RODBC)
library(sqldf)
library(rJava)
library(tcltk)

sqldf("select *, rank() over(partition by Group_A, Group_B order by Value) from DF order by Group_A, Group_B, Group_C ",drv="RSQLServer")