> The table has something like this:
>
> idnamekey
> 1 name1 key1
> 2 name2 key2
> 3 name3 key3
> 4 name1 key1
> 5 name 1 key1
> 6 name2 key2
>
>
> Now I want to search the table for all unique name/key combinations.
>
select name,key from table group b
Hello.
On Mon 2002-12-09 at 13:45:42 +0200, [EMAIL PROTECTED] wrote:
> Please can someone help me with this:
>
> I need to "filter" duplicate entries from my result query, but there's a
> twist...
>
[...]
> Now I want to search the table for all unique name/key combinations.
>
> I tried
> sel
On Mon, 2002-12-09 at 12:45, Petre Agenbag wrote:
> sql,query
[snip]
> I need to "filter" duplicate entries from my result query, but there's a
> twist...
[snip]
> Where name 1 key1 was obviously a typo, yet, I would ideally want to
> filter or flag this through some kind of logic => ( there is alr
sql,query
Hi List
Please can someone help me with this:
I need to "filter" duplicate entries from my result query, but there's a
twist...
The table has something like this:
id namekey
1 name1 key1
2 name2 key2
3 name3 key3
4 name1 key1
5 name 1 k
