db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John T. Dow" <j...@johntdow.com>
Subject Re: finding duplicates?
Date Sat, 14 Feb 2009 04:02:06 GMT
You might start with this:

select OtherKey, count(*) from Table group by OtherKey having count(*) > 1

On Fri, 13 Feb 2009 16:16:54 -0800, Kent Spaulding wrote:

>Hi all,
>I could use a little guidance for solving a tricky (to me, a noob) SQL  
>problem in Derby.
>I have a table with columns like:
>PrimaryKey, Enabled, OtherKey
>The 'OtherKey' values are supposed to be unique, but because we have  
>dirty data - they aren't.
>I want to construct a query to list OtherKey values that appear more  
>than once, and are enabled.
>So for data like:
>the query would return:
>okDupe, "pk02|pk03"
>The PrimaryKeys column is a list of strings, separated by '|'.
>Is this easy to do in Derby?
>Thanks in advance,

View raw message