Re: [GENERAL] Using aggregates in a select query

2000-03-22 Thread Ross J. Reedstrom
On Tue, Mar 21, 2000 at 04:07:20PM -0800, Arthur M. Kang wrote: > Was wondering if there was a way to use an aggregate value in a single > select query to make a calculation within that query... > > Example: > Table has column bool of type boolean with various random boolean > values. > > Want t

Re: [GENERAL] Using aggregates in a select query

2000-03-21 Thread John Henderson
Arthur, I suspect you could create an aggregate function to do it the same way that avg() works more or less. John Henderson >Was wondering if there was a way to use an aggregate value in a single >select query to make a calculation within that query... > >Example: >Table has column bool of type

[GENERAL] Using aggregates in a select query

2000-03-21 Thread Arthur M. Kang
Was wondering if there was a way to use an aggregate value in a single select query to make a calculation within that query... Example: Table has column bool of type boolean with various random boolean values. Want to see if it is possible (in a single select query) to find the percentage of ent