import itertools
for key,group in itertools.groupby('aabbbcmmaaaa'):
print key,list(group)
返回:
a ['a', 'a']
b ['b', 'b', 'b']
c ['c']
m ['m', 'm']
a ['a', 'a', 'a', 'a']
#忽略大小写:
fo...
select Category,count(distinct userId) as UserCount,count(orderId) As OrderCount ,sum(PayMoney) as payMony from [ECP_Core].[dbo].[C_Fund_Detail] where createTime>='2022-03-10' and Categ...