【文件属性】:
文件名称:行转列sql_server
文件大小:2KB
文件格式:TXT
更新时间:2021-12-30 18:06:01
sql
sql server 用于行转列,省得各位去找语句,select to_char(wm_concat('''' || valuelabel || '''')) name
from (select distinct t.valuelabel
from structuredrecruit t)
select *
from (select t.uhid, t.form_name, valuelabel, max(valuedata) valuedata
from structuredrecruit t
group by t.uhid, t.form_name, valuelabel)
pivot(max(valuedata) valuedata