34,590
社区成员
发帖
与我相关
我的任务
分享
--access中的iif相当于sql中的case when
SELECT DISTINCT sserver,count(id) as t
FROM
(SELECT a.id,CASE WHEN substring(a.sserver,3,1)='[' THEN left(a.sserver,2) ELSE CASE WHEN substring(a.sserver,4,1)='[' THEN left(a.sserver,3) ELSE left(a.sserver,4) END END AS sserver
FROM list as a
WHERE isSold=0) aa
GROUP BY sserver ORDER BY sserver