Untitled
unknown
plain_text
2 months ago
262 B
2
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;