久久九九全国免费,麻豆视频一区,久久久久久国产精品久久

oracle 1月-12月數(shù)據(jù)查詢

StringBuilder sql = new StringBuilder();

sql.append("select ");

sql.append("(");

sql.append(" select count(*) from fds_case t where ");

sql.append(" t.belongsystemunid = '28B78C2F0E9ECBA275775794C1058F2A' ");

sql.append(" and (t.occur_time between '2013-01-01' and to_char(last_day(date'2013-01-01'),'YYYY-MM-DD')) ");

sql.append(") as 一月份,");

sql.append("(");

sql.append(" select count(*) from fds_case t where ");

sql.append(" t.belongsystemunid = '28B78C2F0E9ECBA275775794C1058F2A'");

sql.append(" and (t.occur_time between '2013-02-01' and to_char(last_day(date'2013-02-01'),'YYYY-MM-DD')) ");

sql.append(") as 二月份,");

sql.append(" from dual;");

select substr(t.create_time, 0, 4) years,

sum(decode(substr(t.create_time, 6, 2), '01', 1, 0)) 月01,

sum(decode(substr(t.create_time, 6, 2), '02', 1, 0)) 月02,

sum(decode(substr(t.create_time, 6, 2), '03', 1, 0)) 月03,

sum(decode(substr(t.create_time, 6, 2), '04', 1, 0)) 月04,

sum(decode(substr(t.create_time, 6, 2), '05', 1, 0)) 月05,

sum(decode(substr(t.create_time, 6, 2), '06', 1, 0)) 月06,

sum(decode(substr(t.create_time, 6, 2), '07', 1, 0)) 月07,

sum(decode(substr(t.create_time, 6, 2), '08', 1, 0)) 月08,

sum(decode(substr(t.create_time, 6, 2), '09', 1, 0)) 月09,

sum(decode(substr(t.create_time, 6, 2), '10', 1, 0)) 月10,

sum(decode(substr(t.create_time, 6, 2), '11', 1, 0)) 月11,

sum(decode(substr(t.create_time, 6, 2), '12', 1, 0)) 月12,

count(1) alls

from FDS_CASE t

where t.del = 'N'

and t.belongsystemunid = '28B78C2F0E9ECBA275775794C1058F2A'

歡迎大家訪問我的個(gè)人網(wǎng)站萌萌的IT人

posted on 2013-03-19 17:35 一堣而安閱讀(1643) 評(píng)論(0) 編輯收藏所屬分類: oracle


只有注冊(cè)用戶登錄后才能發(fā)表評(píng)論。




網(wǎng)站導(dǎo)航: 博客園 IT新聞 Chat2DB C++博客博問管理
相關(guān)文章: ORA-12154 win7_oracle11g_64位連接32位PLSQL_Developer oracle導(dǎo)出表結(jié)構(gòu)的幾種方法。 oracle在導(dǎo)入時(shí)指定不導(dǎo)入某張表手動(dòng)重建em資料庫 oracle批量插入 ORACLE SEQUENCE用法 left join加上where條件的困惑 ORA-00904標(biāo)識(shí)符無效 oracle的nvl和sql server的isnull （轉(zhuǎn)）