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
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 already a
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
select
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 by name,key;