MATCH_RECOGNIZE get all matches with restarting from first element I created the following example table to get all ABC matches with SQL’s MATCH_RECOGNIZE: