>Hello!
>
>I noticed the DELETE SQL command does not work with group by's like most SQL does.
>I am trying to do:
>
>DELETE FROM GROUPFLDS GROUP BY FNAME,GROUPNO HAVING COUNT(*) > 1 ;
>
>Like I would on Oracle but it does not work.
>
>What I am doing is trying to delete all duplicates on these two columns.
Hi,
Use a subquery here:
DELETE FROM MainFile WHERE FName IN
( SELECT FName, COUNT(*) FROM MainFile GROUP BY Fname HAVING COUNT(*) > 1)