Archives of the TeradataForum
Message Posted: Fri, 21 Jun 2013 @ 10:14:39 GMT
I want to delete those records from Table1 which are present in Table2.
Using below query.
DELETE FROM Table1 WHERE (key1, key2) IN ( SELECT UNIQUE key1, key2 FROM Table2 );
Could any suggest any other fastest alternate way to do so.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|