[sqlite] Compute clauses

[Jeff Edwards]

In Sybase there is a transact SQL extension clause called "compute"

so if I was to write something like:

 select client_id, company from client where client_id <10 order by 
group_code compute sum(client_id)

I would get a result like this:

 client_id   company
 ----------- --------------------------------------------------
           1 Company 1
           2 Company 2
           3 Company 3
           4 Company 4
           5 Company 5
           6 Company 6
           7 Company 7
           8 Company 8
           9 Company 9
Compute Result:
 -----------
          45
is there anything like this in sqllite which can give me a computed 
result ?

Thank you

Jeff Edwards

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