Excel中SUMPRODUCT函数的使用方法

页面:/news/view-380287/ | 耗时:0.5334 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=380287 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=380287 LIMIT 0,1
select * from tbl_Articles_sphinx where id=380287 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(466585,556160,2775316,427895,384795,3526556,3405527,1088504,3177880,669571,2326242,3216544,1753891,1114708,3419219,1111380,1097405,685982,3007678,2145160,1283512,1119488,1177800,3477453,412248,1122266,2067993,3287704,374383,475382) ORDER BY field (ArticleID,466585,556160,2775316,427895,384795,3526556,3405527,1088504,3177880,669571,2326242,3216544,1753891,1114708,3419219,1111380,1097405,685982,3007678,2145160,1283512,1119488,1177800,3477453,412248,1122266,2067993,3287704,374383,475382)