|
{:soso_e130:} 通过查这查那,终于也把这题目的变异点处理掉了,自己都觉得有成就感……
不过看完大家回复的答案,就发现原来山外有山,真的是只有投入才能学到很多很多……
第1题:- Select 部_门 AS 部门,[员工#] AS 员工, [1] AS 第1季度金额, [2] AS 第2季度金额, [3] AS 第3季度金额, [4] AS 第4季度金额 from [查询练习$A:F] Where 部_门 IS NOT NULL
复制代码 第2题:- Select 部_门 AS 部门,[员工#] AS 员工, [1] AS 第1季度金额, [2] AS 第2季度金额, [3] AS 第3季度金额, [4] AS 第4季度金额 from [查询练习$A:F] Where 部_门="A"
复制代码 第3题:- Select 部_门 AS 部门, SUM([1]) AS 第1季度合计金额 from [查询练习$A:F] Where 部_门 IS NOT NULL group by 部_门
复制代码 第4题:- Select 部_门 AS 部门,[员工#] AS 员工, [1] AS 第1季度金额, [2] AS 第2季度金额, [3] AS 第3季度金额, [4] AS 第4季度金额 from [查询练习$A:F] Where 部_门 IS NOT NULL AND [3]>700000
复制代码 第5题:- Select 部_门 AS 部门,MAX([4]) AS 第4季度最大金额 from [查询练习$A:F] Where 部_门 IS NOT NULL group by 部_门
复制代码 第6题:- Select 部_门 AS 部门,[员工#] AS 员工, [1] AS 第1季度金额, [2] AS 第2季度金额, [3] AS 第3季度金额, [4] AS 第4季度金额 from [查询练习$A:F] Where 部_门 IS NOT NULL order by [1]+[2]+[3]+[4] desc
复制代码 |
|