On Tue, Jul 06, 2004 at 10:30:38AM -0400, Paul McNeil wrote: > Good day to all. > > I have a table and want to find duplicate info in the table. I know > duplicated info exists by running the following... > > Select count(*) from myTable -> 141123 > Select distinct(myData) from myTable -> 1411000
I presume there's a typo here: count(*) should have returned a larger number than distinct(myData), not smaller. > So I created a temporary table to store distinct records and want to do a > join with original table to see what records are duplicates. > > Create Temporary Table A > Select distinct(mydata),rowID from myTable; This is a different query than above. What cout do you get from this query: Select distinct(mydata),rowID from myTable; Yes, it will be huge, but you want that count of selected rows. > God Bless > > Paul C. McNeil > Developer in Java, MS-SQL, MySQL, and web technologies. -- Brian Reichert <[EMAIL PROTECTED]> 37 Crystal Ave. #303 Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
