I get this when validating the syntax, please help: ust a heads-up... (Line 3, Col 1) Use specific column names in your SELECT statement. (Line 1, Col 8) Use specific column names in your SELECT statement.
Very true Moses, DISTINCT is a good solution for basic duplication removal, however it is less viable when trying to remove more complicated duplicates. I should have added a "CreatedDate" to my example to show how to dedupe based on Creation Date.