* Petre Agenbag
> The distinct clause will return only one occurrance of the
> implicated field.
> distinctrow would do the same, but for an entire row. what I am
> looking for
> is something like distinctset(field1,field2,field7) , is this what the
> MAX-CONCAT "trick" attempts to do?
Not exactly
head.).
Thanks in any event for your time and interest.
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]
Sent: Friday, August 01, 2003 2:49 AM
To: [EMAIL PROTECTED]
Cc: Petre Agenbag
Subject: Re: help to structure query without using subselects
* Petre Agenbag
[...]
* Petre Agenbag
[...]
> This works:
>
> select distinct name, max(id) as mid from table group by name
>
> but it only returns the name and the highest id for such a name.
>
> if I try this:
>
> select distinct name, max(id) as mid, anything_else from table group by
> name
>
> it returns the FIRST
Hi List
Can anyone help me to do the following without the need of subselects:
I have a table that contains rows where mostly, the only common field is
the "name". The rest of the data fields, even though they are related to
the "name", differs from row to row ( they are things like the address
