Group By 分组

--1源数据(未分组)
SELECT FAccountId,FReasonType,FDateTime,FAmount  
FROM dbo.TMoneyChanges
WHERE FCompanyId=36052
AND FReasonType IN (17,28,37,39,40,41) 
AND FDateTime BETWEEN '20150501' AND '20160601'
ORDER BY FAccountId 

 

--2(按用户分组)
SELECT FAccountId,MAX(FDateTime),SUM(FAmount)
FROM dbo.TMoneyChanges
WHERE FCompanyId=36052
AND FReasonType IN (17,28,37,39,40,41) 
AND FDateTime BETWEEN '20150501' AND '20160601'
GROUP BY FAccountId  ----------分组------------
ORDER BY FAccountId 


--3(按用户和操作类型分组)
SELECT FAccountId,MAX(FDateTime),SUM(FAmount),FReasonType
FROM dbo.TMoneyChanges
WHERE FCompanyId=36052
AND FReasonType IN (17,28,37,39,40,41) 
AND FDateTime BETWEEN '20150501' AND '20160601'
GROUP BY FAccountId,FReasonType  -----分组-----
ORDER BY FAccountId