26 Aug 2011
Updated: 26 Aug 2011
Rating: 2.00/5
Votes: 1
Popularity: 0.00
Licence: CPOL
Views: 9,821
Bookmarked: 1
Downloaded: 0
Another way of getting totals, whether it be by group or set is to use the CUBE and ROLLUP predicates.By group (each grouping of FIELD_DESCRIPTION will have a total sum):SELECT FIELD_DESCRIPTION , SUM(FIELD_VALUE)FROM tbl_DataGROUP BY FIELD_DESCRIPTIONWITH CUBEOr:By Cube...
|