|
本帖最后由 JLxiangwei 于 2015-6-13 09:52 编辑
- transform sum(工资日结) select 月份 f (select format(时间,"m") as 月份,招生管理员,工资日结 f [作业1$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$a:e] where weekday(时间,2) in (6,7)) group by 月份 pivot 招生管理员
- select 会员等级,人数 f (select 等级 as 会员等级,count(姓名) as 人数,len(等级) as 字节 f [作业2$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$a:c] group by 等级) where 字节>0
- transform sum(总工资) select 招生管理员 f(SELECT 招生管理员,iif(时间<39904,'第一季度',iif(时间<39995,'第二季度',iif(时间<40087,'第三季度','第四季度'))) as 季度,工资日结 as 总工资 f [作业3$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$]) group by 招生管理员 pivot 季度
- select 学号,姓名,choose((MID(身份证号,17,1) mod 2)+1,"男","女") as 性别,身份证号,replace(replace(电话,"(",""),") ","-") as 电话,电子邮件 f [学生$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$] where 学号-1<2009
- select 学号,姓名,iif(学号-1000<7,"A组",iif(学号-1000<1000,"B组",iif(学号-1000<1007,"C组","D组"))) as 组别 f [学生$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$]
复制代码 交作业 {:22:}
--------------------------------------------------------------------------------------------------------------------
第一题和效果图有点不一样,没有排序,注意:用format(时间,"m") 后月份字段是文本了
最好用month(时间) 或者val(format(时间,"m"))来代替
——JLxiangwei |
评分
-
查看全部评分
|