_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
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")
蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2018-04-13 23:12:54

讌 一 襴蟆 朱 覓伎 螳. (譟一燕)