oracle数据库，一段行转列的sql，不知道为什么就是报错。

Question

WITH p AS (SELECT fromid,KEYDATA,VALDATA FROM table)
SELECT * FROM p
pivot
( Sum (VALDATA)
FOR KEYDATA
IN ('AllowPartialRequired','BayLocation','ContaminationLevel','CurrentLot','CurrentLoot','RuleViolOCA','Shared','SpecViolOCA','Vendor') );
每次都报错说 SQL command not properly ended
不知道哪里出问题了，还请大家指教

Answer 1

MySQL的行转列、列转行常用函数有concat、concat_ws、group_concat

参考自：
MySQL行转列、列转行常用函数用法介绍 http://www.data.5helpyou.com/article388.html