Select with "different" expression with two conditions

Question

I wonder if there’s any way to make a select using a where for a field with the parameter other than < >, where it has two or more items.

To facilitate follow example:

select * from TAB_DESPESAS where cd_item <> '0' order by cd_processo;

For this query I have more than one code for the field cd_item, which in this case would be a sort of list (codes: 0, 2, 20 and 21). Therefore, I would like to bring in this query all other items, except the list items.

Answer 1

Use the NOT IN

select * from TAB_DESPESAS where cd_item NOT IN ('0','2','20','21') order by cd_processo;

Answer 2

You can use the following command:

SELECT * FROM tabela WHERE COD_STATUS NOT IN ('2','10','5')