惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

freeCodeCamp Programming Tutorials: Python, JavaScript, Git & More
腾讯CDC
cs.AI updates on arXiv.org
cs.AI updates on arXiv.org
L
LINUX DO - 热门话题
D
Darknet – Hacking Tools, Hacker News & Cyber Security
Project Zero
Project Zero
V
Vulnerabilities – Threatpost
Cisco Talos Blog
Cisco Talos Blog
P
Palo Alto Networks Blog
C
Cisco Blogs
A
Arctic Wolf
月光博客
月光博客
The GitHub Blog
The GitHub Blog
T
The Blog of Author Tim Ferriss
量子位
小众软件
小众软件
Latest news
Latest news
OSCHINA 社区最新新闻
OSCHINA 社区最新新闻
Microsoft Security Blog
Microsoft Security Blog
T
The Exploit Database - CXSecurity.com
Security Latest
Security Latest
N
Netflix TechBlog - Medium
K
Kaspersky official blog
人人都是产品经理
人人都是产品经理
Cyber Security Advisories - MS-ISAC
Cyber Security Advisories - MS-ISAC
博客园_首页
Y
Y Combinator Blog
P
Proofpoint News Feed
H
Hackread – Cybersecurity News, Data Breaches, AI and More
M
MIT News - Artificial intelligence
T
Threat Research - Cisco Blogs
S
Schneier on Security
D
Docker
Scott Helme
Scott Helme
MyScale Blog
MyScale Blog
Spread Privacy
Spread Privacy
cs.CL updates on arXiv.org
cs.CL updates on arXiv.org
Threat Intelligence Blog | Flashpoint
Threat Intelligence Blog | Flashpoint
GbyAI
GbyAI
有赞技术团队
有赞技术团队
Google DeepMind News
Google DeepMind News
The Hacker News
The Hacker News
H
Help Net Security
Simon Willison's Weblog
Simon Willison's Weblog
J
Java Code Geeks
C
Cyber Attacks, Cyber Crime and Cyber Security
T
Tenable Blog
B
Blog
Know Your Adversary
Know Your Adversary
IT之家
IT之家

博客园 - 梦飞天蝎

[导入]CCNA认证培训介绍 [导入]硬盘参数解读 [导入]SCSI技术 [导入]常用的硬盘接口类型IDE、SCSI、SATA [导入]SCSI卡(图解) [导入]什么是RAID控制器 [导入]微软Office InfoPath 2003概述(转贴) [导入]关于在MOSS的编辑或新建页面隐藏栏 [导入]FTP两种传输模式小结 [导入]sp_unprepare是做什么用的 [导入]left join 的 右表 加条件 某个字段 is not null 是不是无效啊 [导入]案例入厂前和离职后的旷工都清除掉,但无法清除离职前的旷工记录喔20080304 [导入]案例做出考勤月报表20080303 [导入]SqlServer如何生成动态交叉表查询 [导入]where jzno is not null还可以怎么表达呢 [导入]表变量在存储过程中出现了"必须声明变量"的错误,已经声明了啊 [导入]SQL Server字符串处理函数大全 [导入]sql server 的日期转换函数 [导入]SQL数据文件恢复高级篇
[导入]案例20080220 列出台籍人员全年出勤
梦飞天蝎 · 2008-02-20 · via 博客园 - 梦飞天蝎

select no,name,kqrq,weeks,sksj,ycq,cqxs,kgxs,ycyy,qjxs,jzmc from rb200701 where bmmc like '%台籍%'
union all
select no,name,kqrq,weeks,sksj,ycq,cqxs,kgxs,ycyy,qjxs,jzmc from rb200702 where bmmc like '%台籍%'
union all
select no,name,kqrq,weeks,sksj,ycq,cqxs,kgxs,ycyy,qjxs,jzmc from rb200703 where bmmc like '%台籍%'
union all
select no,name,kqrq,weeks,sksj,ycq,cqxs,kgxs,ycyy,qjxs,jzmc from rb200704 where bmmc like '%台籍%'
union all
select no,name,kqrq,weeks,sksj,ycq,cqxs,kgxs,ycyy,qjxs,jzmc from rb200705 where bmmc like '%台籍%'
union all
select no,name,kqrq,weeks,sksj,ycq,cqxs,kgxs,ycyy,qjxs,jzmc from rb200706 where bmmc like '%台籍%'
union all
select no,name,kqrq,weeks,sksj,ycq,cqxs,kgxs,ycyy,qjxs,jzmc from rb200707 where bmmc like '%台籍%'
union all
select no,name,kqrq,weeks,sksj,ycq,cqxs,kgxs,ycyy,qjxs,jzmc from rb200708 where bmmc like '%台籍%'
union all
select no,name,kqrq,weeks,sksj,ycq,cqxs,kgxs,ycyy,qjxs,jzmc from rb200709 where bmmc like '%台籍%'
union all
select no,name,kqrq,weeks,sksj,ycq,cqxs,kgxs,ycyy,qjxs,jzmc from rb200710 where bmmc like '%台籍%'
union all
select no,name,kqrq,weeks,sksj,ycq,cqxs,kgxs,ycyy,qjxs,jzmc from rb200711 where bmmc like '%台籍%'
union all
select no,name,kqrq,weeks,sksj,ycq,cqxs,kgxs,ycyy,qjxs,jzmc from rb200712 where bmmc like '%台籍%'
 
order by no

[此帖子已被 fzonet 在 2008-2-23 21:29:36 编辑过]
文章来源:http://bbs.fzonet.com/rcds/ShowPost.asp?ThreadID=1633