select tab1.操作代码,t1.操作日期,t1. 号码
((select max(操作日期),号码 from tab1 gruop by 号码) as t1 left join tab1 on
t1.号码=tab1.号码 and t1.操作日期=tab1.操作日期)ff自己加where判断,没调试过噢
((select max(操作日期),号码 from tab1 gruop by 号码) as t1 left join tab1 on
t1.号码=tab1.号码 and t1.操作日期=tab1.操作日期)ff自己加where判断,没调试过噢
(
select 操作代码,号码,max(操作日期)
gruop by 操作代码,号码
where 操作代码<>'FF'
)或者select 操作代码,号码,max(操作日期) into tb2
gruop by 操作代码,号码
where 操作代码<>'FF'你的不是FF,是FF描述得不是很清楚,没太明白你的意思