39. 拼接表字段b.day
var fun = ABS_LOADBEAN("com.plug.FunctionHelper");
//var v_div = fun.funHelper.strAdd("'<div>'","b.Day");
//v_div = fun.funHelper.strAdd(v_div,"'</div>'");
var v_div = "'<div>'||"+"b.Day"+"||'</div>'";
var sql = " select max(ID) ID,NoofWeek,max(Week1) Week1,max(Week2) Week2,max(Week3) Week3,max(Week4) Week4,max(Week5) Week5,max(Week6) Week6,max(Week7) Week7 "
+" from ( "
+" select a.ID,to_number(to_char(b.Year)||(CASE WHEN b.NoofWeek>=10 THEN to_char(b.NoofWeek) ELSE '0'||to_char(b.NoofWeek) END)) as NoofWeek,"
+" case when b.Week=1 then "+v_div+" else '' end as Week1,"
+" case when b.Week=2 then "+v_div+" else '' end as Week2,"
+" case when b.Week=3 then "+v_div+" else '' end as Week3,"
+" case when b.Week=4 then "+v_div+" else '' end as Week4,"
+" case when b.Week=5 then "+v_div+" else '' end as Week5,"
+" case when b.Week=6 then "+v_div+" else '' end as Week6,"
+" case when b.Week=7 then "+v_div+" else '' end as Week7 "
+" from T_HR_WorkCalendar a,tCalendar b"
+" where a.FAttendPeriod={0} and a.FWorkType={1} and to_char(a.FWorkDate,'yyyyMMdd')=b.ID and funit = {2}"
+" ) x"
+" group by NoofWeek"
+" order by Noofweek";
sql
最新文章
- ASP.NET MVC5+EF6+EasyUI 后台管理系统(32)-swfupload多文件上传[附源码]
- 探索Aspnetcore+mysql+efcore
- Hibernate(三)__核心接口和类
- Linux 在 i 节点表中的磁盘地址表中,若一个文件的长度是从磁盘地址表的第 1 块到第 11 块 解析?
- windows下如何github ssh 公钥
- 自定义View的编写
- FreeNAS 9.1.1 发布,网络存储系统 - 开源中国社区
- oozie配置安装与原理
- 201521123104《Java程序设计》第4周学习总结
- 虚拟机中ubuntu-16.04 Linux系统下配置mysql数据库,并在windows下使用navicat远程连接
- 关于ubuntu下qt编译显示Cannot connect creator comm socket /tmp/qt_temp.xxx/stub-socket的解决办法
- PostgreSQL数据库部署之 :PostgreSQL pgadmin4 the application server could not be contacted
- Django 安装 创建项目
- 【转】【JAVA资料免费下载】158个JAVA免豆精品资料汇总——下载目录
- FF中flash滚轮失效的解决方案
- flask的orm框架(SQLAlchemy)-一对多查询以及多对多查询
- [漏洞分析]thinkphp 5.x全版本任意代码执行分析全记录
- POJ 3233 Matrix Power Series(二分等比求和)
- 网络 --- 1 c/s (b/s)架构 ip 初始socket
- PHP Laravel 连接并访问数据库