John, If they are truly duplicates, it shouldn't really matter which one is deleted.
There is no ORDER BY available. If they are not really duplicates, and there is some difference that makes you prefer one be retained over another, then DELETE DUPLICATES is not the way to clean up. People here can help you design a GROUP BY query to identify the near-match rows that you want to eyeball, to manually delete the less-desired row. To do that, we would need to see your table structure and what columns contribute to the "duplicate" definition. Bill On Fri, Jul 18, 2008 at 10:56 AM, John Croson <[EMAIL PROTECTED]> wrote: > Does anyone have an idea as to how R:Base decides which rows get > deleted using this command? Is it first in, last out, based on time > stamp or something? Or do I use an ORDER BY to sort it out? > > TIA! > > -- > John Croson > [EMAIL PROTECTED] > http://pcnorb.blogspot.com/ > http://pcnorb.homelinux.org/ > > >
