Posts

Showing posts with the label rollup aggregation

S) How to take a count of vowel present in a string ?

Image
 Solution: Redefine Format   record   string( 1) data;   end     FBE   data member [ vector "A","a","E","e","I"," i "," O","o","U","u " ]     Sort   Key –Data     Rollup     Key –Data     out : : rollup(in) =   begin     out. data : : in.data ;     out.cc : : count( in.data );   end;