SQL Server ¸ÄΪORACLEµÄÓï·¨ - Oracle / ¿ª·¢

select ID as '²¿ÃűàºÅ', Department as '²¿ÃÅÃû³Æ', 
  [Õýʽ] = Sum ( case when EmployeeType = ' Õýʽ ' then Cnt else 0 end ),
  [ÁÙʱ] = Sum ( case when EmployeeType = ' ÁÙʱ ' then Cnt else 0 end ), 
  [´ÇÍË] = Sum ( case when EmployeeType = ' ´ÇÍË ' then Cnt else 0 end ),
  [ºÏ¼Æ] = Sum ( case when EmployeeType <> '' then Cnt else 0 end ) 
from VDepartmentEmployeeType group by ID, Department

ÉÏÃæµÄsqlÊÇsqlserverµÄ£¬ÊǸö±íµÄÐÐÁÐת»»
[Õýʽ] = Sum (...)£¬¸Ä³ÉoracleÓ¦¸ÃÔõôдÄØ£¿

---

select ID as '²¿ÃűàºÅ', Department as '²¿ÃÅÃû³Æ', 
  Sum ( case when EmployeeType = ' Õýʽ ' then Cnt else 0 end ) Õýʽ,
  Sum ( case when EmployeeType = ' ÁÙʱ ' then Cnt else 0 end ) ÁÙʱ , 
  Sum ( case when EmployeeType = ' ´ÇÍË ' then Cnt else 0 end ) ´ÇÍË,
  Sum ( case when EmployeeType <> '' then Cnt else 0 end ) ºÏ¼Æ 
from VDepartmentEmployeeType group by ID, Department

---

Õâ¸ö
SQL code:
select ID ²¿ÃűàºÅ, Department ²¿ÃÅÃû³Æ,
Sum ( case when EmployeeType = ' Õýʽ ' then Cnt else 0 end ) Õýʽ,
Sum ( case when EmployeeType = ' ÁÙʱ ' then Cnt else 0 end ) ÁÙʱ ,
Sum ( case when EmployeeType = ' ´ÇÍË ' then Cnt else 0 end ) ´ÇÍË,
Sum ( case when EmployeeType <> '' then Cnt else 0 end