22,209
社区成员
发帖
与我相关
我的任务
分享
IF OBJECT_ID('tempdb..#tab') IS NOT NULL
DROP TABLE #tab
CREATE TABLE #tab(
id VARCHAR(200)
)
INSERT INTO #tab
SELECT 'E1212' UNION ALL
SELECT 'E1212' UNION ALL
SELECT 'E1212' UNION ALL
SELECT 'A1212' UNION ALL
SELECT 'A1212'
--测试数据结束
SELECT LEFT(id,1) AS id,COUNT(1) AS cnt
FROM #tab
GROUP BY LEFT(id,1)
id cnt
---- -----------
A 2
E 3
(2 行受影响)