MySQL QUERY TO FIND DUBLICATES IN DATABASE
Hi, All I have a query in MsAccess to find duplicates which works fine. the statement is as follows: SELECT First(table1.field1) AS field1Field, Count(table1.field1) AS NumberOfDups FROM table1 INNER JOIN table2 ON table1.field1 = table2.field1 GROUP BY table1.field1 HAVING (((Count(table1.field1))>1)) I want to now use this statement in MySQL, but it has a problem with the syntax (most probable it does not understand the statements first and count) Could you maybe give me an alternative statement?
try this... just remove the FIRST() SELECT table1.field1 AS field1Field, COUNT(table1.field1) AS NumberOfDups FROM table1 INNER JOIN table2 ON table1.field1 = table2.field1 GROUP BY table1.field1 HAVING NumberOfDups > 1 Steve ----- "The sherminator" <steve.kim41@gmail.com> wrote:
Hi, All
I have a query in MsAccess to find duplicates which works fine. the statement is as follows:
SELECT First(table1.field1) AS field1Field, Count(table1.field1) AS NumberOfDups FROM table1 INNER JOIN table2 ON table1.field1 = table2.field1 GROUP BY table1.field1 HAVING (((Count(table1.field1))>1))
I want to now use this statement in MySQL, but it has a problem with the syntax (most probable it does not understand the statements first and count)
Could you maybe give me an alternative statement?
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
lemmi try that On Wed, Jul 27, 2011 at 3:52 PM, Steve Obbayi <steve@sobbayi.com> wrote:
try this... just remove the FIRST()
SELECT table1.field1 AS field1Field, COUNT(table1.field1) AS NumberOfDups
FROM table1 INNER JOIN table2 ON table1.field1 = table2.field1 GROUP BY table1.field1 HAVING NumberOfDups > 1
Steve
----- "The sherminator" <steve.kim41@gmail.com> wrote:
Hi, All
I have a query in MsAccess to find duplicates which works fine. the statement is as follows:
SELECT First(table1.field1) AS field1Field, Count(table1.field1) AS NumberOfDups FROM table1 INNER JOIN table2 ON table1.field1 = table2.field1 GROUP BY table1.field1 HAVING (((Count(table1.field1))>1))
I want to now use this statement in MySQL, but it has a problem with the syntax (most probable it does not understand the statements first and count)
Could you maybe give me an alternative statement?
_______________________________________________ Skunkworks mailing list
Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
participants (2)
-
Steve Obbayi -
The sherminator