#
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