求高手帮忙写一sql语句

Question

在oracle 9i中TESTBOOK表有这样的数据AUTHOR    BOOKTYPE      BOOKSIZE      COUNTNUM
 张三     探索科学类      10            5000
 李四     军事类          14            4000           
 王二     文学类          15            2000
 李白     文学类          20            7000
 杜甫     军事类          22            8000
 麻子     军事类          11            2000
 张一     哲学类          21            1000
 张二     军事类          14            4000
 张五     哲学类          15            3000
 张六     哲学类          22            5000
现在我要查出 booktype的booksize和countnum的总数
结果要这样BOOKTYPE      SUM(BOOKSIZE)      SUM(COUNTNUM)
探索科学类      10            5000
军事类          61            18000           
文学类          35            9000
哲学类          58            9000请问sql语句怎么写？

Answer 1

select BOOKTYPE  ,    SUM(BOOKSIZE),      SUM(COUNTNUM)
from table
group by BOOKTYPE ;

Answer 2

我再加个order by booktype 可以么？

Answer 3

--直接来就是
select BOOKTYPE,sum(BOOKSIZE),sum(COUNTNUM)
from tb
group by BOOKTYPE

Answer 4

--直接来就是
select BOOKTYPE , SUM(BOOKSIZE), SUM(COUNTNUM)
from table
group by BOOKTYPE 
order by booktype

Answer 5

GROUP BY 放在 ORDER BY 前面就可以了

Answer 6

--summary 
select b.booktype,sum(b.booksize),sum(b.countnum) from testbook b
group by b.booktype order by b.booktype