RE: SQL question: Finding duplicates

[Russell Horn]

> 
> row | foo
> 1   | a
> 2   | c
> 3   | b
> 4   | c
> 5   | a
> 6   | d
> 
> the statement would return me rows 1, 2, 4, and 5.
> 

CREATE TEMPORARY TABLE temptable SELECT *
FROM test
GROUP BY foo
HAVING COUNT( * ) >1
ORDER BY foo ASC ;

SELECT *
FROM test, temptable
WHERE test.foo = temptable.foo
ORDER BY test.row ASC;


-- 
Russell.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]