🚀 go-pugleaf

You should select only the column which you want the distinct value of.  If
you select more than one column in your select statement then it will return
more rows.  The DISTINCT  command is only good for one column distinction.


Tim Mcphail <rhopfinger@earthlink.net> wrote in message
news:38AB51E1.A7B37168@earthlink.net...
> I'm a relative newbie to sql and I'm looking for a solution to the
> following problem.  Any help
> would be greatly appreciated.
>
> I have a two column table.  e.g.-
>
> location     name
> 1               bob
> 2              john
> 2              sam
> 2              frank
> 3              tim
>
> I want to select one of each of the locations.  Where there are multiple
> locations I want just one of
> them with the associated name but I don't care which name.  e.g. -
>
> location     name
> 1               bob
> 2              (john, sam or frank, it doesn't matter which is returned)
>
> 3              tim
>
> I tried distinct but because it applies to the whole table I get the
> same starting table.  I can do
> 'select distinct location' but this only returns the location and I want
> an associated name (if there is
> one).  Thanks in advance.
>
> tim mcphail
> mcphail@umsa7.umd.edu
>
>