Issue with subquery and select Top 1 statement in it
Vertica doesn't seem to support a statement like the one below:
update upatable set Fcst_QTR=(select top 1 qtr_fcst from fivec_qtr a where
I have tried using LIMIT but it is also not allowed by Vertica in a subquery. Any thoughts, ideas and help is welcome! Thank you!