eghawt
|
| Posted: 07/19/2002, 1:52 AM |
|
I would like to aggregate data from a table/query using the GROUP BY clause of SELECT SQL statement.
Is it possible in CCS? If so, how could I actually display data on the web pages, or what type of form/grid should I use.
Thanks
|
|
|
 |
Alex LL
|
| Posted: 07/19/2002, 8:08 AM |
|
Write your query in form's SQL properties. Using a GROUP BY means logically group records by an attribute, so you could use a grid.
Once you wrote a valid SQL query, you can use the results as field names.
E.g. select count(*) as single_total from table group by columnname;
Creating fields you'll see you can use 'count' as attribute.
Regards,
Alessandro
|
|
|
|
|
