I’m attempting to generate a report to list 5 ESNs by ITEM_IDs by MANF_CD from DEALER table.
See attachment: example.txt
I’ve managed to generate the list similar to the above however I have not been able to limit the ESN output to 5 for each ITEM_ID. Any help provided would be much appreciated.