find a repeated value in table1 not in table2 but need the all presence of repeated values. expected result is 4
4
find a repeated values in table1 not in table2. the expected result is 4,4 . i will try joins and cte and union all methods but did not get answer