把前几天和 j9988 讨教的问题贴出来
把前几天和 j9988 讨教的问题贴出来:
表结构:
姓名(pk),日期(pk),金额
以下是数据:
select * into #T
from
(
select '张三' as 姓名,cast('2002-01-01' as datetime) as 日期,100 as 金额
union all
select '张三','2002-02-01',100
union all
select '张三','2002-03-01',110
union all
select '张三','2002-04-01',110
union all
select '张三','2002-05-01',110
union all
select '张三','2002-06-01',100
union all
select '张三','2002-07-01',120
union all
select '李四','2002-02-01',100
union all
select '李四','2002-03-01',110
union all
select '李四','2002-04-01',90
union all
select '李四','2002-05-01',100
union all
select '李四','2002-06-01',100
union all
select '李四','2002-07-01',150
union all
select '王五','2002-02-01',100
union all
select '王五','2002-03-01',90
union all
select '王五','2002-04-01',90
union all
select '王五','2002-05-01',90
union all
select '王五','2002-06-01',100
union all
select '王五','2002-07-01',80
) T
要求查询结果:
姓名,开始日期,结束日期,金额
李四,2002-02-01,2002-02-01,100
李四,2002-03-01,2002-03-01,110
李四,2002-04-01,2002-04-01,90
李四,2002-05-01,2002-06-01,100
李四,2002-07-01,2002-07-01,150
王五,2002-02-01,2002-02-01,100
王五,2002-03-01,2002-05-01,90
王五,2002-06-01,2002-06-01,100
王五,2002-07-01,2002-07-01,80
张三,2002-01-01,2002-02-01,100
张三,2002-03-01,2002-05-01,110
张三,2002-06-01,2002-06-01,100
张三,2002-07-01,2002-07-01,120
可以理解为: 每个人的发薪历史情况!
(个人认为 非常非常 有用,可用于各种含有历史记录(教育经历、工作经历等)的表查询)
稍后贴出参考答案!