[thelist] simple sql question

Matt Warden mwarden at gmail.com
Fri Nov 24 14:05:44 CST 2006

On 11/24/06, Brian Cummiskey <brian at hondaswap.com> wrote:
> SELECT max(fileid) FROM files
> GROUP BY title HAVING count(*) >1

I assume you want to delete the record with the maximum fileid for
each title. Something like this should get you started in the right

delete from files
where fileid in (
     select max(fileid)
     from files
     group by title

This assumes that fileid is the sole member of a candidate key.

Matt Warden
Cleveland, OH, USA

This email proudly and graciously contributes to entropy.

More information about the thelist mailing list