SQLite error near "PIVOT": syntax error

SELECT 
   TYPE, DSMTYPE, REVISION, MODEMTYPE, FWVERSION,
   MAC, TEMP, DATE, TIME, TECHNICIAN 
FROM 
   (SELECT parameterid, parametervalue FROM Product) up 
PIVOT 
   MAX(parametervalue) FOR parameterid IN 
   (TYPE, DSMTYPE, REVISION, MODEMTYPE, FWVERSIO开发者_运维百科N, MAC, TEMP, DATE, TIME, TECHNICIAN)) AS pvt

SQLite error near "PIVOT": syntax error"

---

PIVOT is not a keyword recognized by SQLite. (It appears to be specific to MSSQL.) The full syntax for SQLite is detailed at:

http://www.sqlite.org/lang.html