基本结构,其中t.d在oracle中为date类型 :
select to_char(t.d,'q'),sum(t.d2) from table t group by to_char(t.d,'q')
例(例中take_time是varchar2类型的,在数据库中存的是:2013-09-14 这类数据):
select substr(t.take_time,0,4)||'.'||to_char(to_date(t.take_time, 'yyyy-mm-dd'), 'q') sj, count(*)
from D_VIDEO t
group by substr(t.take_time,0,4)||'.'||to_char(to_date(t.take_time, 'yyyy-mm-dd'), 'q')
order by substr(t.take_time,0,4)||'.'||to_char(to_date(t.take_time, 'yyyy-mm-dd'), 'q')
||为连接符,这样就可以按年季展示结果集了,展示的结果为: