22,207
社区成员
发帖
与我相关
我的任务
分享
;with cte(h,abc) as(
select 'Ha',12353531
union all select 'Ha',13456345
union all select 'Ha',43454568
union all select 'Ha',54534536
union all select 'Ha',64345563
)
select h,COUNT(*)as cnt from cte group by h order by h asc
h cnt
---- -----------
Ha 5
(1 行受影响)