oracle ÊýÖµ±£ÁôСÊýµãÎÊÌâ ÔÚÏßµÈ! - Oracle / ¿ª·¢

select x from ±í
xÊÇnumberÀàÐÍ,°üº¬ÓÐÁ½Î»Ð¡Êý
x²é³öÀ´Ê±±»×Ô¶¯È¥µôºóÃæСÊýµãµÄ0

È磺
0
3.1


ÏÖÔÚÎÒÏë±£ÁôËüÊÇnumberÀàÐÍ£¬¶øÇÒ°üº¬Á½Î»Ð¡Êý
¼´ÎÒÏëÒªµÄ½á¹ûΪ
0.00
3.10

ÏÈлл´ó¼Ò!

---

°ÑxµÄÊý¾ÝÀàÐ͸ÄΪnumber(11,2)

---

¶þÂ¥²é³öÀ´µÄÊÇ×Ö·ûÐÍ£¬²»·ûºÏÐèÇó°¡

ÎÒ±í½á¹¹ÒѾ­ÊÇnumber(18,2)

ÏÖÔÚÎÒÇó³öÀ´½á¹ûÒ»sumºóºóÃæСÊýµã¾ÍûÁË
¶øÎÒºóÃ滹ÐèÒªÄÃÕâ¸ö½á¹ûÀ´union all 
µ±ÎÒÏñ¶þÂ¥ÄÇÑùдµÄʱºò union all ʱ¾Í»áÌáʾÊý¾ÝÀàÐͲ»Æ¥Åä

---

ÒýÓÃ

¶þÂ¥²é³öÀ´µÄÊÇ×Ö·ûÐÍ£¬²»·ûºÏÐèÇó°¡

ÎÒ±í½á¹¹ÒѾ­ÊÇnumber(18,2)

ÏÖÔÚÎÒÇó³öÀ´½á¹ûÒ»sumºóºóÃæСÊýµã¾ÍûÁË
¶øÎÒºóÃ滹ÐèÒªÄÃÕâ¸ö½á¹ûÀ´union all
µ±ÎÒÏñ¶þÂ¥ÄÇÑùдµÄʱºò union all ʱ¾Í»áÌáʾÊý¾ÝÀàÐͲ»Æ¥Åä

×îºÃÊÇÈ«²¿´úÂë

ÄǾÍÏÈsum(x) È»ºóÔÚto_char(sum(x),'fm999990.00') from tb

---

SQL code:

Select * from F_NEWTRACKMONTHHR t1 where t1.date_id = 201004
union all
select t.date_id date_id,
t.managecom_id managecom_id,
t.initgrade initgrade,
t.companyage companyage,
t.reporttype reporttype,
sum(t.begin_agent_num) begin_agent_num,
sum(t.end_agent_num) end_agent_num,
sum(t.active_agent_num) active_agent_num,
sum(t.satisfy_agent_num) satisfy_agent_num,
su