: discussion@acfug.orgSubject: Re: [ACFUG Discuss] group count ability
what DB?If on Oracle you can add a column to your query called say countofcolumntogroupby populated by using a aggregate function as a analytic functionCOUNT(*) OVER (PARTITION BY columntogroupby ) AS countofcolumnttogeroupby
: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Seth Tepfer
Sent: Thursday, August 17, 2006 9:54 PM
To: [EMAIL PROTECTED]; discussion@acfug.org
Subject: [ACFUG Discuss] group count ability
When doing a group on a query, is there a simple way to
identify the number of rows in each group
Return Receipt
Your RE: [ACFUG Discuss] group count ability
document