Posts

Showing posts with the label group by operations

S) Rollup Accumulation Function Scenario

Image
          Solution:-     Ip - DML     Record   String( “| ”)id ;   String(“\n ”)data ;   End;     Rollup      Key :id     out : : rollup(in) =   begin     out. data : : string_join (accumulation( in.data ), "" );     out.id : : in.id;   end ;     Op- DMl     Record   String( “| ”)id ;   String(“\n ”)data ;   end