34,575
社区成员
发帖
与我相关
我的任务
分享
SELECT NOTES_ID,MOBILE,COUNT(*)
FROM A
GROUP BY NOTES_ID,MOBILE
DECLARE @TB TABLE([RECEIVESMS_ID] INT, [NOTES_ID] VARCHAR(10), [MOBILE] VARCHAR(11))
INSERT @TB
SELECT 83, 'bailaxiusx', '13734039384' UNION ALL
SELECT 84, 'SXADM', '13734039384' UNION ALL
SELECT 97, 'bailaxiusx', '13734039384' UNION ALL
SELECT 101, 'bailaxiusx', '13734039384' UNION ALL
SELECT 102, 'bailaxiusx', '13734039384' UNION ALL
SELECT 100, 'bailaxiusx', '13734039384' UNION ALL
SELECT 98, 'bailaxiusx', '13934116969' UNION ALL
SELECT 99, 'bailaxiusx', '13934116969'
SELECT NOTES_ID,MOBILE,COUNT(*) AS num
FROM @TB
WHERE NOTES_ID ='bailaxiusx'
GROUP BY NOTES_ID,MOBILE
/*
NOTES_ID MOBILE num
---------- ----------- -----------
bailaxiusx 13734039384 5
bailaxiusx 13934116969 2
*/
SELECT NOTES_ID,MOBILE,COUNT(*)
FROM tb
GROUP BY NOTES_ID,MOBILE