oracle sql 分组求最大值后,要显示其它列
select
t_a.a,t_a.b,max(t_a.c) c,
?
MAX (t_a.d)KEEP (DENSE_RANK FIRST
????? ORDER BY t_a.c _ DESC)? d_
from t_a
group by
t_a.a,t_a.b
?
发布时间: 2012-07-28 12:25:13 作者: rapoo
oracle sql 分组求最大值后,要显示其它列
select
t_a.a,t_a.b,max(t_a.c) c,
?
MAX (t_a.d)KEEP (DENSE_RANK FIRST
????? ORDER BY t_a.c _ DESC)? d_
from t_a
group by
t_a.a,t_a.b
?