Hi Scott,
Here is my novice question: I need to find duplicates in "Batch" category when I issued this query:
SELECT * FROM QA WHERE Batch=439584414;
Result: 90577 1 2661 5334 JulieAnt 25 5 5 439584414 2004-10-03 00:00:00 2004-10-03 00:00:00 0 90575 1 5657 5334 JulieAnt 25 5 5 439584414 2004-10-03 00:00:00 2004-10-03 00:00:00 0
How do I issue a query that finds duplicated Batch number?
SELECT Batch, COUNT(*) as Nr FROM QA GROUP BY Batch HAVING Nr > 1
Regards,
Jeremy
-- Jeremy Cole (currently in Bangalore) Technical Yahoo - MySQL (Database) Geek
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
