SELECT x.a, DECODE (minb, maxb, minb, NULL ), sumofc FROM (SELECT a, MIN (b) minb, SUM (c) sumofc FROM tbl GROUP BY a) x, (SELECT a, MAX (b) maxb FROM tbl GROUP BY a) y WHERE x.a = y.a;
可以再简化一下 select a,decode(max(b),min(b),max(b),null),sum(c) from tablename group by a;
UP!select job,decode(max(mgr),min(mgr),max(mgr),null)as aa,sum(sal) from emp group by job;用EMP表试的!
maxb, minb,
NULL
), sumofc
FROM (SELECT a, MIN (b) minb, SUM (c) sumofc
FROM tbl
GROUP BY a) x,
(SELECT a, MAX (b) maxb
FROM tbl
GROUP BY a) y
WHERE x.a = y.a;
select a,decode(max(b),min(b),max(b),null),sum(c)
from tablename
group by a;
group by job;用EMP表试的!