面试题
来源:互联网 发布:剑三捏脸数据 编辑:程序博客网 时间:2024/04/28 06:28
转换成
select Name,(select ClassName from [dbo].[EmpCalendar] as Sub where Sub.CalendarDate='2005-5-01' and Sub.Name=Pare.Name )as D20050501 ,(select ClassName from [dbo].[EmpCalendar] as Sub1 where Sub1.CalendarDate='2005-5-02' and Sub1.Name=Pare.Name )as D20050502 ,(select ClassName from [dbo].[EmpCalendar] as Sub2 where Sub2.CalendarDate='2005-5-03' and Sub2.Name=Pare.Name )as D20050503 ,(select ClassName from [dbo].[EmpCalendar] as Sub3 where Sub3.CalendarDate='2005-5-04' and Sub3.Name=Pare.Name )as D20050504 ,(select ClassName from [dbo].[EmpCalendar] as Sub4 where Sub4.CalendarDate='2005-5-05' and Sub4.Name=Pare.Name )as D20050505 from [dbo].[EmpCalendar] as Paregroup by Pare.Name
0 0
- 面试题....
- 面试题
- 面试题
- 面试题
- 面试题
- 面试题
- 面试题
- 面试题
- 面试题
- 面试题
- 面试题
- 面试题
- 面试题
- 面试题
- 面试题
- 面试题
- 面试题
- 面试题
- DBCP1.3数据库连接泄漏问题
- Spring JavaMailSender发送邮件
- C++——NOIP例题——坐标系
- 2016亚洲区域赛现场赛china final A题
- 仿知乎日报(6)_主题界面内容区加载布局
- 面试题
- Python学习笔记
- 颜色
- 文章标题 UVA 11374 : Airport Express(最短路--dijkstra)
- Android仿微信朋友圈图片展示效果,图片查看器
- 【BZOJ 1023】[SHOI2008]cactus仙人掌图
- QT 动态加载dll
- eclipse+tomcat9 使用多个虚拟域名访问多个web项目
- 纯代码给wordpress增加说说/微博/微语功能