I have to generate a report of the top 10 occurrences and the # of times they occur. For e.g in the table below
ID Name 1 John 2 John 3 Mary 4 Mary 5 MarySo I need to generate a report which shows John - 2 ; Mary - 3; Peter - 5 and Mitt - 5. Names with the # of times they occur. Is there any way to get this done.
Thx-Amit