一个非常复杂的问题..如能解决您就是我的救命恩人..

bmin1117

问题描述如下:  图片和附件内容一致



工作簿1.zip (4.19 KB, 下载次数: 26)

2013-6-12 15:55 上传

点击文件名下载附件

Renco

要说效果，联合查询就能达到

amazeyeli

update a
set 加价截止日 = format(date(),"yyyymmdd")
from tb as a
where 结清状态 = '示结清'
and (select count(1) from tb where 外键 = a.外键 and 加价截止日>=a.加价截止日) = 2

bmin1117

amazeyeli 发表于 2013-6-13 09:21
update a
set 加价截止日 = format(date(),"yyyymmdd")
from tb as a

您的意思是加一列 结清状态 吗?
把当天的日期更新到数据库中好说..
关键是取出数据时..如何显示当天的日期..
我看您给的这段命令应该是把当天的日期更新进数据库吧?

amazeyeli

select 外键,结清状态,加价起始日,加价截止日
from tb as a
where 结清状态 = '示结清'
and (select count(1) from tb where 外键 = a.外键 and 加价截止日>=a.加价截止日) = 1
union all
select 外键,结清状态,加价起始日,format(date(),"yyyymmdd") as 加价截止日
from tb as a
where 结清状态 = '示结清'
and (select count(1) from tb where 外键 = a.外键 and 加价截止日>=a.加价截止日) = 2

amazeyeli

select 外键,结清状态,加价起始日,加价截止日
from tb as a
where 结清状态 = '示结清' or 结清状态 = '已结清'
and (select count(1) from tb where 外键 = a.外键 and 加价截止日>=a.加价截止日) = 1
union all
select 外键,结清状态,加价起始日,format(date(),"yyyymmdd") as 加价截止日
from tb as a
where 结清状态 = '示结清'
and (select count(1) from tb where 外键 = a.外键 and 加价截止日>=a.加价截止日) = 2