Select CntNo,EmpCo,Effect_date,End_Date,Effect_Period From vwContracts tem where Effect_date=(select max(Effect_date) from vwContracts where EmpCo=tem.EmpCo)
Select EmpCo,max(Effect_date)From vwContracts group by EmpCo
为什么非要这样: Select CntNo,EmpCo,Effect_date,End_Date,Effect_Period From vwContracts tem where Effect_date=(select max(Effect_date) from vwContracts where EmpCo=tem.EmpCo) 我这样不行? Select CntNo,EmpCo,Effect_date,End_Date,Effect_Period From vwContracts tem where Effect_date=(select max(Effect_date) from vwContracts where EmpCo=vwContracts .EmpCo) 就差别在后面这儿啊 EmpCo=tem.EmpCo) EmpCo=vwContracts .EmpCo)
select CntNo,EmpCo,Effect_date,End_Date,Effect_Period from vwContracts where Effect_Period = select max(CONVERT(int,Effect_date,112)) from vwContracts group by EmpCo
如何理解大力这个语句啊?. 为什么非要这样: Select CntNo,EmpCo,Effect_date,End_Date,Effect_Period From vwContracts tem where Effect_date=(select max(Effect_date) from vwContracts where EmpCo=tem.EmpCo) 我这样不行? Select CntNo,EmpCo,Effect_date,End_Date,Effect_Period From vwContracts tem where Effect_date=(select max(Effect_date) from vwContracts where EmpCo=vwContracts .EmpCo) 就差别在后面这儿啊 EmpCo=tem.EmpCo) EmpCo=vwContracts .EmpCo)
group by EmpCo
Select CntNo,EmpCo,Effect_date,End_Date,Effect_Period From vwContracts tem where Effect_date=(select max(Effect_date) from vwContracts where EmpCo=tem.EmpCo)
我这样不行?
Select CntNo,EmpCo,Effect_date,End_Date,Effect_Period From vwContracts tem where Effect_date=(select max(Effect_date) from vwContracts where EmpCo=vwContracts .EmpCo) 就差别在后面这儿啊
EmpCo=tem.EmpCo)
EmpCo=vwContracts .EmpCo)
where Effect_Period = select max(CONVERT(int,Effect_date,112)) from vwContracts group by EmpCo
为什么非要这样:
Select CntNo,EmpCo,Effect_date,End_Date,Effect_Period From vwContracts tem where Effect_date=(select max(Effect_date) from vwContracts where EmpCo=tem.EmpCo)
我这样不行?
Select CntNo,EmpCo,Effect_date,End_Date,Effect_Period From vwContracts tem where Effect_date=(select max(Effect_date) from vwContracts where EmpCo=vwContracts .EmpCo) 就差别在后面这儿啊
EmpCo=tem.EmpCo)
EmpCo=vwContracts .EmpCo)