Taken directly from Brian’s page and added here so I don’t have to keep searching for this the one time a year that I need it,
delete T1
from MyTable T1, MyTable T2
where T1.dupField = T2.dupField
and T1.uniqueField > T2.uniqueField
Note to myself to delete duplicates
Recent
From the blog
-
Stop Texting Your Friends: SMS Was Never Designed to Be Secure
SMS is great for flight notifications, appointment reminders, and delivery updates. But for conversations with friends and family, it’s time to move…
-
Gheist Can Turn Stolen GitHub Access Into Stolen Production Credentials
If you use GitHub to build and deploy software, take a few minutes to understand Gheist. You do not need to be…
-
Patching your PHP/WordPress on AWS? Don’t Do It Twice
Last week a critical PHP vulnerability dropped. That same week, I realized the WordPress image my blog runs on was never going…
-
Your AI Just Violated First Normal Form. And All Its Tests Passed.
We are the kings of the code. That may sound a little grandiose, but consider what happens when we use AI agents…
-
When AI Is Smart Enough to Get Around the Rules
AI is becoming an extraordinary programming partner. But sometimes its eagerness to help is exactly why we need to pay attention. I…
Leave a Reply