sql - PostgresSQL: Why can't I add two MAX to this view -


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