Re: using distinct in a single column to get multiple rows
From: Gerard H. Pille <ghp_at_skynet.be>
Date: Mon, 19 Sep 2011 20:14:50 +0200
Message-ID: <4e77866f$0$5044$ba620e4c_at_news.skynet.be>
test_at_m.com wrote:
> Hi,
>
> I need to get a unique column but I also need to return multiple rows.
>
> Using the following doesn't work to get the unique last name since it
> gets all unique columns.
>
> select unique userid, title, address
> from myTable
> where etc.........
> order by userid
>
> The userid will be returned multiple times because the other columns
> cause the row to be unique.
>
> How do I get a unique userid while still returning the other rows.
>
> Thanks!
> Dave
>
Date: Mon, 19 Sep 2011 20:14:50 +0200
Message-ID: <4e77866f$0$5044$ba620e4c_at_news.skynet.be>
test_at_m.com wrote:
> Hi,
>
> I need to get a unique column but I also need to return multiple rows.
>
> Using the following doesn't work to get the unique last name since it
> gets all unique columns.
>
> select unique userid, title, address
> from myTable
> where etc.........
> order by userid
>
> The userid will be returned multiple times because the other columns
> cause the row to be unique.
>
> How do I get a unique userid while still returning the other rows.
>
> Thanks!
> Dave
>
maybe an example to clarify your requirements? Received on Mon Sep 19 2011 - 13:14:50 CDT