select a.*
from f_ss a
where A is not null and Aa=10
and 检查序号 in ( select max(检查序号) as 检查序号
from f_ss
group by 序号
)
from f_ss a
where A is not null and Aa=10
and 检查序号 in ( select max(检查序号) as 检查序号
from f_ss
group by 序号
)
FROM f_ss as a
WHERE a.aa = 10
and a.a not is null
and a.检查序号 = ( Select max(b.检查序号) FROM f_ss as b where a.序号 = b.序号)
巨集列了