Why make a list of SQL tips? This is going to be an ever-growing list of SQL tips, shortcuts that I find useful day-to-day. I don’t claim to be the best at SQL but I figure if I keep track of some useful techniques and ideas here then it won’t hurt! The idea originally came […]
This snippet was handy for to remove duplicate rows in SQL. These had crept into a Postgres database table as a result of a dodgy join. This is sort of a note to self, really. There are probably more than a couple of ways of doing this but the best example I came up with
How to remove duplicate rows in SQL (works with Postgres) Read More »