如何统计每一条 comments 的记录?每个备注在备注列值中都有一个不同的数字.我需要根据备注内容对记录进行分组,而不是使用cid###
.需要按备注分组,但每条备注都有一些CID的动态变量,不包括CID号需要分组
示例Remarks
:
Remark1-cid11
Remark1-cid22
Remark1-cid33
组1的计数应为3
样本数据
Remark Id CreatedOn ProcessName
------------------------------------------------------------------------
Remark1-cid22 1 2023-12-27 18:02:54.4102746 P1
Remark2-cid23 2 2023-12-27 18:02:54.4102746 P1
Remark3-cid24 3 2023-12-27 18:02:54.4102746 P1
Remark4-cid25 4 2023-12-27 18:02:54.4102746 P1
Remark1-cid26 5 2023-12-27 18:02:54.4102746 P1
Remark2-cid27 6 2023-12-27 18:02:54.4102746 P1
Remark3-cid28 7 2023-12-27 18:02:54.4102746 P1
Remark4-cid29 8 2023-12-27 18:02:54.4102746 P1
期望输出
CreatedOn Remark Count Group
-----------------------------------
2023-12-27 Remark1 2 Group1
2023-12-27 Remark2 2 Group2
2023-12-27 Remark3 2 Group3
2023-12-27 Remark4 2 Group4
我试过的查询
select
Remark, Count (Id)
from
IPocumentRequests
group by
Remark
having
Remark like '%Remark1%'
or Remark like '%Remark2%'
or Remark like '%Remark3%'
or Remark like '%Remark4%'
输出
Remark (No column Name)
------------------------------
Remark1 -cid11 1
Remark2 -cid22 1
Remark3-cid33 1
Remark4-cid44 1
Remark1-cid55 1
Remark2-cid66 1
Remark3-cid77 1
Remark4-cid88 1