converting SQL select list into unique values
I have a non-unique column in a MySQL table - I have looked hard for a way in SQL to convert the results of a SELECT into a list of unique values. I know how to define a table at CREATE to have UNIQUE columns but this is not what I want to do. For example : If the result of the SELECT is : 1, 3, 3, 4, 2, 6, 8, 9, 4, 2, 3, 6 I would like to return: 1, 2, 3, 4, 6, 8, 9 i.e. only the unique values of the list. any pointers ? if SQL can't do this, can Zope ? (I'm sure Zope can do it, it can do everything :) Darcy -- --------------------------------------------------- Ph: (734) 764 3377 Email: darcyc@engin.umich.edu URL: http://www-personal.engin.umich.edu/~darcyc/ --------------------------------------------------- 'If you're not part of the solution, you're part of the precipitate' ..... Steven Wright
Darcy Clark wrote:
I have a non-unique column in a MySQL table - I have looked hard for a way in SQL to convert the results of a SELECT into a list of unique values. I know how to define a table at CREATE to have UNIQUE columns but this is not what I want to do.
For example :
If the result of the SELECT is : 1, 3, 3, 4, 2, 6, 8, 9, 4, 2, 3, 6
I would like to return: 1, 2, 3, 4, 6, 8, 9
i.e. only the unique values of the list.
any pointers ? if SQL can't do this, can Zope ? (I'm sure Zope can do it, it can do everything :)
Darcy
If I remember right... select not_unique from table GROUP BY not_unique; The group by aggregate will do the thing you ask for. -- Best regards / Mvh., Steen Suder, sysadm kollegie6400.dk -|- OpenSource --- Sign of the time Scan-Aqua ADVARSEL WARNING http://www.uk.k64.dk/sfs/Scan-Aqua/
or even select distinct non_unique from table ----- Original Message ----- From: "Steen Suder" <CAB@earthling.net> To: <zope@zope.org> Sent: Friday, January 07, 2000 10:28 PM Subject: Re: [Zope] converting SQL select list into unique values
Darcy Clark wrote:
I have a non-unique column in a MySQL table - I have looked hard for a way in SQL to convert the results of a SELECT into a list of unique values. I know how to define a table at CREATE to have UNIQUE columns but this is not what I want to do.
For example :
If the result of the SELECT is : 1, 3, 3, 4, 2, 6, 8, 9, 4, 2, 3, 6
I would like to return: 1, 2, 3, 4, 6, 8, 9
i.e. only the unique values of the list.
any pointers ? if SQL can't do this, can Zope ? (I'm sure Zope can do it, it can do everything :)
Darcy
If I remember right...
select not_unique from table GROUP BY not_unique;
The group by aggregate will do the thing you ask for.
-- Best regards / Mvh., Steen Suder, sysadm kollegie6400.dk -|- OpenSource --- Sign of the time
Scan-Aqua ADVARSEL WARNING http://www.uk.k64.dk/sfs/Scan-Aqua/
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
participants (3)
-
Darcy Clark -
Phil Harris -
Steen Suder