Re: [SQL] Applying SUM twice in the same query.

Rodger Donaldson <[EMAIL PROTECTED]> writes: > What I really want to do with total is to derive a > proportion of number of server:number of servers, something like: Only way to do that is with a sub-select, because all the aggregates appearing in a single query are going to be computed over the

[SQL] Applying SUM twice in the same query.

I have a table structured: server_name|server_version |number ---++-- Apache |1.3.11 | 1 Netscape-Enterprise|2.01| 1 Apache |1.1.3 | 2 Initially I wanted to extract the total count by