Home > database >  Consult a great god SQL group summary data
Consult a great god SQL group summary data

Time:09-28

Data
Taskarea functionhander
510105/publishingApproval/pr
120110/publishingApproval/enterprise
511129/publishingApproval/pr
510302/publishingApproval/needs
510104/publishingApproval/case
510104/publishingApproval/case
510302/publishingApproval/needs
510101/publishingApproval/case



Want
Count (*) taskarea functionhander
1 12/publishingApproval/enterprise
1 1201/publishingApproval/enterprise
1 120110/publishingApproval/enterprise
3 51/publishingApproval/case
3, 5101/publishingApproval/case
2, 510104/publishingApproval/case
1, 510101/publishingApproval/case
51/publishingApproval/needs 1
1 5103/publishingApproval/needs
1 510302/publishingApproval/needs
51/publishingApproval/pr 2
1 5101/publishingApproval/pr
1 510105/publishingApproval/pr
1 5111/publishingApproval/pr
1 511129/publishingApproval/pr
  • Related