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-sql/
|
Nielsenhome.net |
|
User login |
| Copyright 2003-2007 Nick Nielsen |