Thanks for your reply...

So both Except and Minus are same...

Thanks for your reply...

So finally we cannot use DELETE in Merge....

Hi,

Iam new to vertica,

Can anyone explain in detail difference between MINUS and EXCEPT

Thanks in advance

Srinivas

Hi all, I have created two tables Z_Location and Z_New_Location with following structure: create table edw_pro.Z_Location(UID Numeric(3), col1 Numeric(5,2), col2 Numeric(5,2),Cnt Numeric(2),Name Char(15)) create table edw_pro.Z_New_Location(UID Numeric(3), col1 Numeric(5,2), col2 Numeric(5,2),Cnt Nu...