So it is pretty straight forward to do:

```
Select Val from MyTable where Val not in ('100','200','300'....)

```

1. How do I write a query so that I select values from the list. eg how do I do something like `Select * from ('100','200','300'....)` so that the output is:

```
100    
200    
300    
...

```
2. Further, How do I do something like `select * from ('100','200','300'....) that are not in MyTable.Val` column?