這是 ES2015 的新語法 (ES2015還算新嗎...?) 名為: Property Shorthand http://es6-features.org/#...
https://www.mobile01.com/topicdetail.php?f=508&t=5063568
在DW環境底下, 我會這麼寫.Select Groups,SUM(case when Years='2017' then Balance else 0 end)...
select Groups,[2017] as 'Balance-2017',[2018] as 'Balance-2018' from( select G...
update table1 r inner join ( select product , employee , number from table1 wher...
paicheng0111的鐵人檔案