220
edits
Changes
Jump to navigation
Jump to search
→Cleaning the Companybase table
FROM (SELECT DISTINCT coname, statecode, datefirstinv FROM companybase1 WHERE alwaysusflag = 1 AND undisclosedflag = 0)a;
--44770
By looking at the counts you can see that there is still 1 duplicate key in the table. Let's find it another way.
