I would like to know if there is any way to make a select
using a where
for a field with a parameter other than < >
, with two or more items.
To facilitate following example:
select * from TAB_DESPESAS where cd_item <> '0' order by cd_processo;
For this query I have more than one code for the cd_item
field, 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 items in the list.