can anyone tell me what is the use of group by in rs tables and how to use group by in tables (when we have to use )...if possible please gimme some examples..
Groups can be seens as a presentation hierarchy. Within a group, only the values defined by the grouped columns are available (e.g. Grouping by order id will make the values of an order per orderid accessible within the group). in addition you can use the group footer or header to aggregate values (like sums of OrderdItems).
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment