how we can get result as reverse filter in c\al

suppose a table conatins records 1,2,3,4,5,6,7,8,9,10

and i have records in other table  like 1,3,4,5

then it is easy to get records from main table 1,3,4,5 by using filter function or setrange function....


but i want to get result set from main table like 2,6,7,8,9,10. is there any function to get these type of result or i have to write the logic for it ?