Compare number value with != (not equals)
SQL> CREATE TABLE products
2 (
3 id NUMBER(6),
4 name VARCHAR2(50),
5 descr VARCHAR2(4000),
6 subcategory VARCHAR2(50),
7 subcat_desc VARCHAR2(2000),
8 category VARCHAR2(50),
9 weight_class NUMBER(2)
10 );
Table created.
SQL>
SQL>
SQL>
SQL> select id, category, weight_class
2 from products
3 where weight_class != 1;
no rows selected
SQL>
SQL>
SQL> drop table products;
Table dropped.
SQL>
Related examples in the same category