S
subs
I have a table in the below format- For example Customer A and Dzip
678 is being served from ozip 099 twice and 011 once
ozip dzip customer
099 678 A
011 678 A
099 678 A
121 875 B
122 875 B
122 875 B
I need the below format for the above table. the data in the brackets
indicate the no of times ozip appears in the table for a particular
set of dzip,customer
ozip dzip customer
099(2),011(1) 678 A
121(1),122(2) 875 B
Please let me know the query which will give the data in the above
format. Thanks in advance
678 is being served from ozip 099 twice and 011 once
ozip dzip customer
099 678 A
011 678 A
099 678 A
121 875 B
122 875 B
122 875 B
I need the below format for the above table. the data in the brackets
indicate the no of times ozip appears in the table for a particular
set of dzip,customer
ozip dzip customer
099(2),011(1) 678 A
121(1),122(2) 875 B
Please let me know the query which will give the data in the above
format. Thanks in advance