CodeGuru Forums - MS Access Crosstab Query to Standard SQL

CodeGuru Forums - MS Access Crosstab Query to Standard SQL:
The below code will give the functionality of MS Access Crosstab Query

"SELECT Field2, Field3, Field4, SUM(DECODE(Field6,Val1,Count(Field1),0)) AS Val1, SUM(DECODE(Field6,Val2,Count(Field1),0)) AS Val2, SUM(DECODE(Field6,Val3,Count(Field1),0)) AS Val3 FROM [Table] GROUP BY Field2, Field3, Field4 WHERE Field5 IS NOT NULL"

SELECT
Field2,
Field3,
Field4,
SUM(DECODE(Field6,Val1,Count(Field1),0)) AS Val1,
SUM(DECODE(Field6,Val2,Count(Field1),0)) AS Val2,
SUM(DECODE(Field6,Val3,Count(Field1),0)) AS Val3
FROM
[Table]
GROUP BY
Field2,
Field3,
Field4
WHERE
Field5 IS NOT NULL