SQL Tricks

I always have to Google SQL tricks, because I don't use it enough to memorize this stuff. Here are good pages containing the tricks I use.

How to find duplicate rows:
http://www.xaprb.com/blog/2006/10/09/how-to-find-duplicate-rows-with-sq…