Re: [sqlite] Compute clauses

[Jeff Edwards]

I appreciate your response but perhaps you misunderstand me.

What I illustrated was a way to have totals after the detail.  The way 
to get this in Sybase is to use the "compute" clause.

I am after something similar in sqlite if it exists.

Thanks,

Jeff Edwards

On 05/03/2004, at 8:33 PM, Peter Pistorius wrote:

Yup.

	SELECT SUM(client_id) FORM client;

That will return the sum of client_id;

Regards,
PeterP


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]