"jose isaias cabrera" <[EMAIL PROTECTED]> writes:
> "C.Peachment" wrote,
>
>
>> On Sat, 5 May 2007 19:58:19 -0400, jose isaias cabrera wrote:
>>
>>
>>>Greetings!
>>
>>>imagine this data content,
>>
>>>c1, c2, 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?
>>
>> select distinct c1 from tablename;
>
> Thanks.
>
> Ok, I am going to push my luck. :-) Imagine the same data, what if I wanted
> to get the sum of the other two columns also? I know how to do it one at a
> time, so in this instance I would have to do 3 separate call using sum or
> total, but is there a way that I could do it on the same call and get the sum
> of columns c2 and c3, so that I would get something like this,
>
> a,11,19
> b,3,4
> c,6,9
>
> Yes, I know. I am pushing my luck. :-)
How about something like
SELECT c1, SUM(c2), SUM(c3)
FROM tablename
GROUP BY c1;
Cheers,
Derrell
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
