#
select down.downparaversionid || '|' || e.unionno, down.downparaversion,&n
如題:有一張表EMP,里面有兩個字段:name,chengji 有三條記錄,分別表示語文(name) 70分,數學(name) 80分,英語(name) 58分,請
示例:with temp as (select '1,2,3' nums, 'a' names f
pivot的格式select from( inner_query)pivot(aggreate_function for pivot_column in ( list of values))orde