Hi Folks,

Is there a way to select one field distinctly but still return all the
others?

i.e.

Table
Name Address Tel
Test 123 Str 23456
Test 56 Str 21233
Hello 67 Town 232323

SELECT DISTINCT Name
But return in the query Address & Telephone as well

Not quite sure how this can be done.

Thanks

A

Hi again,

I have found the solution & hope you find this helpful

GROUP BY Name HAVING COUNT(DISTINCT Name)=1

Will fix the example problem.

A

UKuser wrote:
> Hi Folks,
>
> Is there a way to select one field distinctly but still return all the
> others?
>
> i.e.
>
> Table
> Name Address Tel
> Test 123 Str 23456
> Test 56 Str 21233
> Hello 67 Town 232323
>
> SELECT DISTINCT Name
> But return in the query Address & Telephone as well
>
> Not quite sure how this can be done.
>
> Thanks
>
> A