On Sat, 5 May 2007 19:58:19 -0400, jose isaias cabrera wrote:

>Greetings!

>imagine this data content,

>c1, c1, c3
>a, 1, 2
>b, 3, 4
>c, 5, 6
>a, 9, 8
>a, 1, 9
>c, 1, 3

>I would like to get a list of all the items in c1.  So, the return would be,

>a,
>b,
>c

>I know how to do it programmatically, but is there a way to get it right 
>from SQLite?

>thanks,

>josé

select distinct c1 from tablename;




-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to