Re: having count

[Jim Blackburn]

Dan Weissmann wrote:
> 
> Am trying to recall the command that lets a user edit duplicate records. I
> tried EDIT * FROM <table> HAVING COUNT <colID> > 1 but that brings up all
> records in the table.
> 

Try:
 EDIT * FROM <table> WHERE <colID> in(select <colID> from <table> GROUP BY <colID> 
HAVING COUNT <*> > 1)

Jim Blackburn
Kodiak