select v2.a,v2.b,v2.c
from (select SN a,max(RetCNT) b from T_history
group by SN) v1,
(select SN a,RetCNT b,Fail_Code c from T_history
) v2
where v1.a=v2.a and
v1.b=v2.b
最初由 greennut1977 发布
[B]select v2.a,v2.b,v2.c
from (select SN a,max(RetCNT) b from T_history
group by SN) v1,
(select SN a,RetCNT b,Fail_Code c from T_history
) v2
where v1.a=v2.a and
v1.b=v2.b [/B]
可以,我也是想到这条语句
是否还有别的办法?期待...
如果每个SN,只需要显示一条Retcnt 最大的记录,可以这样:
SELECT SN, RetCNT, Fail, Code FROM (
SELECT SN, RetCNT, Fail, Code, RANK() OVER (PARTITION BY SN ORDER BY RetCNT DESC) rn FROMT_history )
WHERE rn = 1;