Untitled
unknown
plain_text
a year ago
262 B
3
Indexable
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;