[SQL] Select by priority

2000-07-15 Thread Prasanth A. Kumar
I need some suggestions on how to construct a particular select that I need. I have a table of addresses where the primary key is the persons_id and a address_type field. The address_type field is a character which specifies whether the address is for the home, work, or mailing. A person can have

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

2000-07-15 Thread Tom Lane
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