On Thu, Jul 15, 2010 at 02:44:54PM -0400, Ted Rolle Jr. scratched on the wall:
> The first step is to identify which rows have duplicate primary key (my
> table has no primary keys, but it still works) values:
If a set of columns has duplicate values they are, by definition,
not a primary key
qlite] Removing duplicate entries from a database
I just found an elegant query to identify duplicate entries in a
table. It is from Microsoft.
http://support.microsoft.com/kb/139444
Here's the information:
create table t1(col1 int, col2 int, col3 char(50))
insert into t1 values (1, 1, 'data v
I just found an elegant query to identify duplicate entries in a
table. It is from Microsoft.
http://support.microsoft.com/kb/139444
Here's the information:
create table t1(col1 int, col2 int, col3 char(50))
insert into t1 values (1, 1, 'data value one')
insert into t1 values (1, 1, 'data value
3 matches
Mail list logo
