SQLite error near "PIVOT": syntax error

Question

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, FWVERSION, MAC, TEMP, DATE, TIME, TECHNICIAN)) AS pvt

SQLite error near "PIVOT": syntax error"

score 1 · Answer 1 · answered Sep 15 '11 at 04:37

1

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

answered Sep 15 '11 at 04:37

Thanks. I want to do like this in SqLie. .http://stackoverflow.com/questions/7416524/pivot-in-sqlite – George Varghese Sep 15 '11 at 08:25

SQLite error near "PIVOT": syntax error

1 Answers1