A
Ankita
Guest
I am new to progress 4gl. i have one query where I have to count number of sales order for particular customer.
for eg: I have table as so_mstr and so_cust is my customer name field and so_nbr is my sale order number field.
in SQL I tried like this , select so_cust,count(distinct so_nbr) from so_mstr group by so_cust.
pls help me in progress. Thanks.
Continue reading...
for eg: I have table as so_mstr and so_cust is my customer name field and so_nbr is my sale order number field.
in SQL I tried like this , select so_cust,count(distinct so_nbr) from so_mstr group by so_cust.
pls help me in progress. Thanks.
Continue reading...