Funny enough, I couldn’t find this snippet of sql code online. I needed to copy a column within the same table to another.
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:
Alan Feekery likes ASP.NET and likes to blog about the little and big things he does with it.
He also likes designing websites when staring at code too long. =p
Based on more than forty interviews with Jobs conducted over two years—as well as interviews with more than a hundred family members, friends, adversaries, competitors, and colleagues—Walter Isaacson has written a riveting story of the roller-coaster life and searingly intense personality of a creative entrepreneur whose passion for perfection and ferocious drive revolutionized six industries: personal computers, animated movies, music, phones, tablet computing, and digital publishing.
