InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comThu, 20 Nov 2008 10:27:22 GMT20http://www.teradata.com/teradataforum/Topic11782-9-1.aspxYou can use analytics group functions :INSERT INTO table1 ( amt )SELECT CASE WHEN t2.amt = MAX(t2.amt) OVER() THEN 0 ELSE t2.amt ENDFROM table2 AS t2;Thu, 12 Jun 2008 10:17:12 GMTal1_24http://www.teradata.com/teradataforum/Topic11782-9-1.aspxYou can use analytics group functions :INSERT INTO table1 ( amt )SELECT CASE WHEN t2.amt = MAX(t2.amt) THEN 0 ELSE t2.amt ENDFROM table2 AS t2;Thu, 12 Jun 2008 10:14:41 GMTal1_24http://www.teradata.com/teradataforum/Topic11782-9-1.aspxthe query u r tryng to run is syntacticaly wrong....try using thisSELECT CASE WHEN amt = COL_C THEN 0 ELSE amt ENDFROM t2,(SELECT MAX(amt)FROM t2) TAB_1 (COL_C).Wed, 11 Jun 2008 11:50:41 GMTamit_dwhhttp://www.teradata.com/teradataforum/Topic11782-9-1.aspxFor example:insert into table1(amt)selectcase when t2.amt = max(t2.amt) then 0 else t2.amt endfromTable2 t2i'm getting an error 3504: Selected non-aggregate values should be part of the associated group.Any suggessions please...-Sujatha-Mon, 09 Jun 2008 23:06:11 GMTSujatha