Untitled

unknown

plain_text

2 months ago

262 B

Indexable

Never

WITH DuplicateRows AS (
    SELECT *,
           COUNT(*) OVER (PARTITION BY VendorCode, SourceLoc, Destination, EquipmentType, ShippingType, HazardousMaterials) AS DuplicateCount
    FROM your_table_name
)

SELECT *
FROM DuplicateRows
WHERE DuplicateCount > 1;