Selection with various differences conditions (SQLSERVER)

Question

I wonder if there is any way to improve this selection:

SELECT * FROM table WHERE id <> 15 AND id <> 17 AND id <> 23 ... id <> N

I don’t have a certain set interval and the ids are selected by checkbox in html, ie I can have N ids. There is some syntax in SQL or Sqlserver that can improve this type of query?

Answer 1

You can use the IN, would look like this:

SELECT * FROM table WHERE id NOT IN (15, 17, 23);

Answer 2

You can use the NOT IN:

SELECT * FROM table WHERE id not in (15, 17, 23/*, N*/)