Hi, Something like:
CREATE TABLE deduped AS SELECT col1, col2, MAX(col3), MAX(col4) FROM table GROUP BY col2, col2 That will give you one row per distinct col1, col2, and you can chose the aggregating function to get the appropriate values from the other columns. Alex On 14 September 2011 22:10, Koert Kuipers <ko...@tresata.com> wrote: > what is the easiest way to remove rows which are considered duplicates > based upon a few columns in the rows? > so "create table deduped as select distinct * from table" won't do... >
