SELECT
a.Date,
a.Class,
SUM(a.amount),
b.note,
b.Name
FROM
tablename1 a
LEFT OUTER JOIN tablename2 b ON a.ID = b.ID
GROUP BY a.Class
...全文
16759打赏收藏
oracle 中 GROUP BY 必须跟select中用到的所有字段?那么。。。
如果select中有许多字段,我只想GROUP BY一个字段那要怎么写啊? SELECT a.Date, a.Class, SUM(a.amount), b.note, b.Name FROM tablename1 a LEFT OUTER JOIN tablename2 b ON a.ID = b.ID GROUP BY a.Class
SELECT
a.Date,
a.Class,
(select SUM(a.amount) from tablename1 c
where a.class=c.class
group by c.class) as amount,
b.note,
b.Name
FROM
tablename1 a
LEFT OUTER JOIN tablename2 b ON a.ID = b.ID