Untitled
unknown
plain_text
2 years ago
5.7 kB
8
Indexable
SELECT 'WAREHOUSE' AS column_name, WAREHOUSE, COUNT(*) AS duplicates FROM TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION GROUP BY WAREHOUSE HAVING COUNT(*) > 1 UNION ALL SELECT 'COMPANY' AS column_name, COMPANY, COUNT(*) AS duplicates FROM TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION GROUP BY COMPANY HAVING COUNT(*) > 1 UNION ALL SELECT 'ZONE' AS column_name, ZONE, COUNT(*) AS duplicates FROM TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION GROUP BY ZONE HAVING COUNT(*) > 1 UNION ALL SELECT 'ASSIGNMENTZONE' AS column_name, ASSIGNMENTZONE, COUNT(*) AS duplicates FROM TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION GROUP BY ASSIGNMENTZONE HAVING COUNT(*) > 1 UNION ALL SELECT 'SIZE' AS column_name, SIZE, COUNT(*) AS duplicates FROM TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION GROUP BY SIZE HAVING COUNT(*) > 1 UNION ALL SELECT 'MAXVOLUME' AS column_name, MAXVOLUME, COUNT(*) AS duplicates FROM TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION GROUP BY MAXVOLUME HAVING COUNT(*) > 1 UNION ALL SELECT 'TOTALLOCATIONS' AS column_name, TOTALLOCATIONS, COUNT(*) AS duplicates FROM TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION GROUP BY TOTALLOCATIONS HAVING COUNT(*) > 1 UNION ALL SELECT 'LOCATIONSWITHINVENTORY' AS column_name, LOCATIONSWITHINVENTORY, COUNT(*) AS duplicates FROM TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION GROUP BY LOCATIONSWITHINVENTORY HAVING COUNT(*) > 1 UNION ALL SELECT 'EMPTYLOCATIONS' AS column_name, EMPTYLOCATIONS, COUNT(*) AS duplicates FROM TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION GROUP BY EMPTYLOCATIONS HAVING COUNT(*) > 1 UNION ALL SELECT 'PERCENTOCCUPIEDBYVOLUME' AS column_name, PERCENTOCCUPIEDBYVOLUME, COUNT(*) AS duplicates FROM TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION GROUP BY PERCENTOCCUPIEDBYVOLUME HAVING COUNT(*) > 1 UNION ALL SELECT 'PERCENTOCCUPIEDBLOCATION' AS column_name, PERCENTOCCUPIEDBLOCATION, COUNT(*) AS duplicates FROM TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION GROUP BY PERCENTOCCUPIEDBLOCATION HAVING COUNT(*) > 1 UNION ALL SELECT 'LOCATIONOCCUPIEDBYVOLUME' AS column_name, LOCATIONOCCUPIEDBYVOLUME, COUNT(*) AS duplicates FROM TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION GROUP BY LOCATIONOCCUPIEDBYVOLUME HAVING SQL query for finding duplicates. veerendra kumar meka WAREHOUSE, COMPANY,ZONE, ASSIGNMENTZONE, SIZE, MAXVOLUME, TOTALLOCATIONS, LOCATIONSWITHINVENTORY, EMPTYLOCATIONS, PERCENTOCCUPIEDBYVOLUME, PERCENTOCCUPIEDBLOCATION, LOCATIONOCCUPIEDBYVOLUME, VOLUMEOCCUPIED, UNITS, DETERMINATION_ZONE I have these columns in my table TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION Write an sql query to find duplicates in each and every column To find duplicates in each and every column of the table TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION, you can use the following SQL query: sql Copy code SELECT 'WAREHOUSE' AS column_name, WAREHOUSE, COUNT(*) AS duplicates FROM TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION GROUP BY WAREHOUSE HAVING COUNT(*) > 1 UNION ALL SELECT 'COMPANY' AS column_name, COMPANY, COUNT(*) AS duplicates FROM TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION GROUP BY COMPANY HAVING COUNT(*) > 1 UNION ALL SELECT 'ZONE' AS column_name, ZONE, COUNT(*) AS duplicates FROM TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION GROUP BY ZONE HAVING COUNT(*) > 1 UNION ALL SELECT 'ASSIGNMENTZONE' AS column_name, ASSIGNMENTZONE, COUNT(*) AS duplicates FROM TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION GROUP BY ASSIGNMENTZONE HAVING COUNT(*) > 1 UNION ALL SELECT 'SIZE' AS column_name, SIZE, COUNT(*) AS duplicates FROM TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION GROUP BY SIZE HAVING COUNT(*) > 1 UNION ALL SELECT 'MAXVOLUME' AS column_name, MAXVOLUME, COUNT(*) AS duplicates FROM TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION GROUP BY MAXVOLUME HAVING COUNT(*) > 1 UNION ALL SELECT 'TOTALLOCATIONS' AS column_name, TOTALLOCATIONS, COUNT(*) AS duplicates FROM TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION GROUP BY TOTALLOCATIONS HAVING COUNT(*) > 1 UNION ALL SELECT 'LOCATIONSWITHINVENTORY' AS column_name, LOCATIONSWITHINVENTORY, COUNT(*) AS duplicates FROM TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION GROUP BY LOCATIONSWITHINVENTORY HAVING COUNT(*) > 1 UNION ALL SELECT 'EMPTYLOCATIONS' AS column_name, EMPTYLOCATIONS, COUNT(*) AS duplicates FROM TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION GROUP BY EMPTYLOCATIONS HAVING COUNT(*) > 1 UNION ALL SELECT 'PERCENTOCCUPIEDBYVOLUME' AS column_name, PERCENTOCCUPIEDBYVOLUME, COUNT(*) AS duplicates FROM TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION GROUP BY PERCENTOCCUPIEDBYVOLUME HAVING COUNT(*) > 1 UNION ALL SELECT 'PERCENTOCCUPIEDBLOCATION' AS column_name, PERCENTOCCUPIEDBLOCATION, COUNT(*) AS duplicates FROM TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION GROUP BY PERCENTOCCUPIEDBLOCATION HAVING COUNT(*) > 1 UNION ALL SELECT 'LOCATIONOCCUPIEDBYVOLUME' AS column_name, LOCATIONOCCUPIEDBYVOLUME, COUNT(*) AS duplicates FROM TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION GROUP BY LOCATIONOCCUPIEDBYVOLUME HAVING veerendra kumar meka Continue COUNT(*) > 1 UNION ALL SELECT 'VOLUMEOCCUPIED' AS column_name, VOLUMEOCCUPIED, COUNT() AS duplicates FROM TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION GROUP BY VOLUMEOCCUPIED HAVING COUNT() > 1 UNION ALL SELECT 'UNITS' AS column_name, UNITS, COUNT() AS duplicates FROM TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION GROUP BY UNITS HAVING COUNT() > 1 UNION ALL SELECT 'DETERMINATION_ZONE' AS column_name, DETERMINATION_ZONE, COUNT() AS duplicates FROM TL2.BI_VIEW.ACTIVE_LOCATION_UTILIZATION GROUP BY DETERMINATION_ZONE HAVING COUNT() > 1;
Editor is loading...