DECLARE @t TABLE ([name] VARCHAR(20))
INSERT INTO @t
SELECT '全晓辉' UNION ALL
SELECT '全市的' UNION ALL
SELECT '第三代' UNION ALL
SELECT '撒地方' UNION ALL
SELECT '撒旦'
SELECT MAX(LEFT([name],1)) AS [name],COUNT(1) AS 'count' FROM @t GROUP BY LEFT([name],1) ORDER BY [count] DESC, [name] ASC
2011-06-25