Are PIVOT and UNPIVOT available as SQL statements?
I'm just learning how to use PIVOT and UNPIVOT in SQL, but I'm getting an error when I try to use UNPIVOT:
"
Parse error at line 5, column 9. Encountered: FOR"
I think I've otherwise got the query right. Are PIVOT and UNPIVOT operators allowed in Zoho Reports query tables?