FindDuplicateRows

FindDuplicateRows Function

Identify duplicate rows in a table. Duplicates can be identified either across all columns or for the specified column(s). For each set of duplicate rows, the first entry is selected.

Syntax

FindDuplicateRows (table Table, scalar Column1, scalar Column2 ...)

Arguments

Argument	Description
table Table	A table of the tables to be used as source material
scalar Column	Name of the column to use in checking for duplicate rows

Examples:

FindDuplicateRows ([[FusionTestTable]], null)

Returns duplicate rows that are duplicates in all columns in FusionTestTable.

FindDuplicateRows([[FusionTestTable]],'VarcharColumn', 'DoubleColumn')

Returns the duplicate rows that are duplicates only in the specified column(s) in FusionTestTable.