On Wed, Mar 14, 2001 at 03:48:28PM -0900, Josh Burroughs wrote:
> We recently moved our hardware inventory database off of access (yay!)
> over to mysql. During it's days as an access database it aquired a
> numbered of duplicate entries. In every case (or at least the ones I'm
> working on) the s
Select serialNo, count(serialNo) serNoCount from table group by serialNo
order by 2 desc
This will give you a list of all the unique serial numbers in your table.
The ones with serNoCount>1 are your duplicates. Without the capability to
do subselects (yes, we all know...it's coming in the mythic
