>Dear all,
>
>I got a small portion of code which I cannot understand what it does,
>
>SET DELETED ON
>SET SAFETY OFF
>select ins_id, count(sampnum); <---------
>from spitem;
>where end_ass 2;
>into table q_anasum;
>group by ins_id;
>order by ins_id
>
>Can anyone help me figure out what the function (count()) do here? Does it
>output a number or something?
>
>Any help appreciated, thanks in advance.
>
>Best regards,
>Ron.
It will return the number of records per group ins_id.
output will be ins_id field & total no. of records.