i trying create simple view using following query:
select max(row) ,"email" ,max("dateupdated") "staging"."duplicatesubscribers" group "email"
it throwing following error:
error: column "max" specified more once
can explain missing have tried query , worked well.
try aliasing selected expressions:
select max(row) max_row, "email", max("dateupdated") max_dateupdated "staging"."duplicatesubscribers" group "email"
Comments
Post a Comment