SQL & Distinct Results

If you are working through a large list of potentially similar entries for maybe a cascading dropdown for manual location entry then you might find the DISTINCT sql command quite valuable.

This query returned 3800+ counties with tons of double entries:

Add in our special DISTINCT keyword and we get just 91 unique counties:

Tags: SQL