分组求和
摘要：
SELECT COUNT(*) Num, ProductNameFROM (SELECT CASE WHEN Params LIKE '%ipad%' THEN 'iPad'WHEN Params LIKE '%iphone%' THEN 'iPhone'ELSE 'android' END AS ProductNameFROM AZPLATFORM.DBO.Log_ServiceLog lsWHERE ServiceCode='PDA_USR_LOGIN' AND((@StartDate=' 阅读全文
posted @ 2013-03-20 14:40 sisibest 阅读(146) 评论(0) 推荐(0) 编辑