G
Guest
Hi,
I have following query results sorted on Customer Name.
CustomerName OrderNumber
ABC 1245
ABC 4878
XYZ 1000
XYZ 1200
OPQ 1300
I want the query not to repeat duplicate CustomerName and give result like
CustomerName OrderNumber
ABC 1245
4878
XYZ 1000
1200
OPQ 1300
Please advise how to stop duplicate CustomerName.
Thanks,
Rakesh
I have following query results sorted on Customer Name.
CustomerName OrderNumber
ABC 1245
ABC 4878
XYZ 1000
XYZ 1200
OPQ 1300
I want the query not to repeat duplicate CustomerName and give result like
CustomerName OrderNumber
ABC 1245
4878
XYZ 1000
1200
OPQ 1300
Please advise how to stop duplicate CustomerName.
Thanks,
Rakesh