End Google Ads 201810 - BS.net 01 --> hi


i have following query which works in sqlserver 2005 but same query shows the error in my sql is there any other syntax plz help
i working on pivote table and qury run in sql2005 but not in mysql why?



create view myview as

select * from dbo.master1
pivot
(
count(EmpName)
for EmpSubGrp in
(EG3 ,TM5 ,TMA ,TMC ,TM1 ,TM2 ,OP6 ,OP7 ,TMB )
) as p