You can do this using the following steps:
Find the sequence groups per groupid
List the sequence numbers you're expecting
Use a partitioned outer join to join each groupid&grp to the list of sequence numbers
Exclude rows where the sequenceno is null in the output. This will give you the missing sequence numbers along with which groupid and group they'...