For example, I want to return all records from the luser table that have a duplicate logged IP. Or Duplicate EMail. Sort of a reverse-DISTINCT query. I looked around a few sites, but none offered any mention of this, nor do I know what the keyword would be anyway..MSDN doesn't have a SQL language reference that I could find, etc.
Is there a keyword for this? Or will I have to return all rows and loop through myself? ugh. That's a bit of a pain with 100k + lusers..though speed isn't important since it's admin-only...but still!