日韩超碰人人爽人人做人人添,亚洲欧洲在线一区,91精品国产综合久久婷婷香蕉

oracle 1月-12月數據查詢

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'

歡迎大家訪問我的個人網站萌萌的IT人

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


只有注冊用戶登錄后才能發表評論。




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