Archives of the TeradataForum

Message Posted: Thu, 18 Aug 2005 @ 08:03:30 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Sree,

I think you meant this...

     DELETE FROM test a
     WHERE a.rowid in
     (
     SELECT x.max_rowid as DEL_ROWID FROM
          (SELECT a, b, c, MAX(rowid) as MAX_ROWID FROM test
          GROUP BY a, b, c
          HAVING COUNT(1) > 1) x,
         test y
      WHERE x.a = y.a
      AND x.b = y.b
      AND x.c = y.c
      AND x.max_rowid <> y.rowid);

Regards,

Sanjaya

	<Prev	Next>		<<First	<Prev	Next>	Last>>