>
> ps: I just think postresql could make this easyly. Don't you think ? Any
> function or anything else.
What's hard about the self-join? That's how SQL works.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
When my information changes, I alter my conclusions. What do you do sir?
You are correct. Sorry my mistake. The SQL statement is correct and I find
the duplicate records.
ps: I just think postresql could make this easyly. Don't you think ? Any
function or anything else.
Thank you so much.
Ezequias
2007/2/2, Shoaib Mir <[EMAIL PROTECTED]>:
Where do you see the sec
Ezequias Rodrigues da Rocha wrote:
Hi list,
I am making some data minning and would like to know if someone tell
me how to retrieve the duplicate records based in one or two fields of
my table.
Any help would be welcomed.
You can use a simple query like this one:
select t1.id, t2.id
from t
The only table in my query is "mytable".
The part (select field1, field2, count(*) from mytable group by field1,
field2 having count(*) > 1)
counts how many records have the same field1 and field2 and returns a
record per combination of field1 and field2 that have more than one (=
duplicates)
The
Where do you see the second table in it?
I guess here:
A = mytable
B = (select field1, field2, count(*) from mytable group by field1, field2
having count(*) > 1)
So that is all around one table that is 'mytable', where A and B are just
the aliases.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.
Thank you but are you talking of two tables ? I intent to check in only one
table.
Please explain to me.
Ezequias
2007/2/2, Bart Degryse <[EMAIL PROTECTED]>:
select *
from mytable A, (select field1, field2, count(*) from mytable group by
field1, field2 having count(*) > 1) B
where A.field1 =
select *
from mytable A, (select field1, field2, count(*) from mytable group by
field1, field2 having count(*) > 1) B
where A.field1 = B.field1 and A.field2 = B.field2
>>> "Ezequias Rodrigues da Rocha" <[EMAIL PROTECTED]> 2007-02-02
14:48 >>>
Hi list,
I am making some data minning and would like
That has been asked in the past a number of time too, you can look at the
following for details -->
http://archives.postgresql.org/pgsql-novice/2006-06/msg00093.php
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 2/2/07, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> wrote:
Hi list,
I a
Hi list,
I am making some data minning and would like to know if someone tell me how
to retrieve the duplicate records based in one or two fields of my table.
Any help would be welcomed.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Atenci