本文提供了一个SQL查询示例，展示了如何从多个表中联接数据并按特定条件进行分组和排序。具体包括：联接Table1、Table2和Table3，筛选指定时间段内的记录，并按UserID分组计算总金额。
SELECT a.[UserID],b.[Name],sum (c.[Money]+c.[Bank])as TotalMoney
FROM Table1 a(nolock)
LEFT JOIN Table3 c(nolock) ON a.[UserID]=c.[UserID], Table2 b(nolock)
WHERE a.[UserID] = b.[UserID] and a.[Time] >= '2011-01-01' AND a.[Time] <= '2011-12-31'
GROUP BY a.[UserID],b.[Name]
ORDER BY a.[Time] DESC
FROM Table1 a(nolock)
LEFT JOIN Table3 c(nolock) ON a.[UserID]=c.[UserID], Table2 b(nolock)
WHERE a.[UserID] = b.[UserID] and a.[Time] >= '2011-01-01' AND a.[Time] <= '2011-12-31'
GROUP BY a.[UserID],b.[Name]
ORDER BY a.[Time] DESC
扫一扫
1446
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
