Hi,
I have a scenario where data is arranged as follows:
TABLE1 =
ID NAME
102 JOEL
256 MARK
269 MARK
270 JOSH
369 AMY
699 AMY
And I would like to see the ouptut as follows:
NAME occurence
JOEL 1
MARK 1
MARK 2
JOSH 1
AMY 1
AMY 2
Any suggestions are welcome.
Regards BI DWH BALA