Tag: set and multiset tables in teradata

SET or MULTISET tables

We know that in Teradata all the tables are either SET or MULTISET. The difference between SET and MULTISET tables is –  SET tables – SET tables did not allow duplicate values in the table. e.g. COLUMN 1          COLUMN 2          COLUMN 3          COLUMN 4 A                            b                            c                            d H                           g                            y                            k A             …

Continue reading