| _覓 | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁 |
|
FrontPage › RODBC
|
|
|
library("RODBC")
conn <- odbcConnect("36",uid="dbid", pwd="password")
data <- sqlQuery(conn, "
select
accountkey
, sum(saleamt) amt
, log(sum(saleamt)) log_amt
from cji_eis.PubSales.Fact_Sales
where datekey between 20100601 and 20100630
and gamekey = 20
group by
accountkey
")
hist(data$log_amt)
DB襦 ロ蠍
library("RODBC")
conn <- odbcConnect("36",uid="dbid", pwd="password")
.
.
.
.
#x_data 一危壱
sqlSave(conn,x_data,tablename="dbo.result")
鏤
|
蟾覿 螳 企 覦 豐螳 朱伎 豐襯 朱 貅讌 る 企至 蟾. 襷谿螳讌襦 襷 ロ 襷企 覦 襷 覦蟆 譯手 貍 覿蠍磯ゼ 襷 蠏碁讌 る 蠏瑚 襷豺 豐襯 手鍵 企 蟆螻 螳. (T. 殊) |