Igor Tandetnik wrote:
>
> flakpit <[EMAIL PROTECTED]> wrote:
>> Is there a way of querying the database to list all duplicate entries
>> from a column in the same table?
>>
>> Something like "SELECT * FROM mytable WHERE last NOT UNIQUE"
>
> select * from mytable t1 where exists (
> select *
select * from mytable
where last in (
select last from mytable group by last_name having count(*) > 1
)
Probably slow on a big table.
-Clark
- Original Message
From: flakpit <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Monday, April 28, 2008 8:33:36 AM
Subject: [sqlite]
Hello Igor,
sorry, i was too fast. The following does it:
create table mytable (a string, b string);
insert into mytable (a,b) values ('Joe', 'Smith');
insert into mytable (a,b) values ('Ann', 'Smith');
insert into mytable (a,b) values ('Fred', 'Miller');
select * from mytable where b in
(
sel
flakpit wrote:
> Is there a way of querying the database to list all duplicate entries from a
> column in the same table?
>
> Something like "SELECT * FROM mytable WHERE last NOT UNIQUE"
>
> fred, johnson
> roger, johnson
>
>
An unoptimised 'off the top of my head' solution would be:
select * f
Martin Engelschalk
<[EMAIL PROTECTED]> wrote:
> Hi,
>
> let the table have two columns, "a" and "b". Then
>
> select a, count(b)
> from yourtable
> group by a
> having count(b) > 1
>
> returns 'fred' and 'roger'.
No it doesn't. It returns an empty set. Try it.
Igor Tandetnik
_
flakpit <[EMAIL PROTECTED]> wrote:
> Is there a way of querying the database to list all duplicate entries
> from a column in the same table?
>
> Something like "SELECT * FROM mytable WHERE last NOT UNIQUE"
select * from mytable t1 where exists (
select * from mytable t2 where t1.last=t2.last
Hi,
let the table have two columns, "a" and "b". Then
select a, count(b)
from yourtable
group by a
having count(b) > 1
returns 'fred' and 'roger'.
Martin
flakpit wrote:
> Is there a way of querying the database to list all duplicate entries from a
> column in the same table?
>
> Something like
7 matches
Mail list logo
