search for: bestbird

hi, I met some problems in R, plz help me. 1. How to do a intersect operation among several groups in one list, without a loop statement? (I think It may be a list) create data: myData <- data.frame(product = c(1,2,3,1,2,3,1,2,2), year=c(2009,2009,2009,2010,2010,2010,2011,2011,2011),value=c(1104,608,606,1504,508,1312,900,1100,800)) mySplit<- split(myData,myData$year)

hi, nice people I needs to compute the product whose annual sales values are all among the top 100 using R ( version 2.15.0) data is stored in the MSSQL database. data structure( sales table's fields): productID, time, value I have found the SQL solution below: SQL solution is as below: -------------------------------------------------------------- WITH