Compare number value with >
SQL> CREATE TABLE customers
2 (
3 id NUMBER,
4 address VARCHAR2(40),
5 postal_code VARCHAR2(10),
6 city VARCHAR2(30),
7 state_province VARCHAR2(40),
8 income_level VARCHAR2(30),
9 credit_limit NUMBER
10 );
Table created.
SQL>
SQL>
SQL> select id, state_province, credit_limit
2 from customers
3 where state_province = 'UT'
4 and credit_limit > 10000;
no rows selected
SQL>
SQL>
SQL> drop table customers;
Table dropped.
Related examples in the same category