enter image description here from this table i have missing doc_no from each store.
I want to find the missing doc_no and i’m expected results like this enter image description here. Each store DO_NO sequence start number is different ST01 START with 1 and ST02 start with 2 and ST03 starts with 3.
please help me write the query to get missing doc_no by store_code.
Thanks
1