纵表转换为横表
表结构
paramkey | runval | owner |
---|---|---|
x | 111 | 0 |
y | 111 | 0 |
z | 111 | 0 |
SELECT
MAX (CASE paramkeyWHEN ‘x’ THEN runva ELSE ‘0’ END) AS x,
MAX (CASE paramkey WHEN ‘y’ THEN runval ELSE ‘0’ END) AS y,
MAX (CASE paramkey WHEN ‘z’ THEN runval ELSE ‘0’ END) AS z
FROM
USER_PARAMINFO
WHERE
“OWNER” = ${ownerId}