Comparison operator with number value and order by
SQL> SQL> SQL> CREATE TABLE product ( 2 product_name VARCHAR2(25), 3 product_price NUMBER(4,2), 4 quantity_on_hand NUMBER(5,0), 5 last_stock_date DATE); Table created. SQL> SQL> INSERT INTO product VALUES ('Small Widget', 99, 1, '15-JAN-03'); 1 row created. SQL> INSERT INTO product VALUES ('Widget', 75, 1000, '15-JAN-02'); 1 row created. SQL> INSERT INTO product VALUES ('Product 1', 50, 100, '15-JAN-03'); 1 row created. SQL> INSERT INTO product VALUES ('Product 2', 25, 10000, null); 1 row created. SQL> SQL> SQL> SQL> SELECT * FROM product WHERE quantity_on_hand = 1; PRODUCT_NAME PRODUCT_PRICE QUANTITY_ON_HAND LAST_STOC ------------------------- ------------- ---------------- --------- Small Widget 99 1 15-JAN-03 1 row selected. SQL> SQL> SELECT * FROM product WHERE quantity_on_hand < 500; PRODUCT_NAME PRODUCT_PRICE QUANTITY_ON_HAND LAST_STOC ------------------------- ------------- ---------------- --------- Small Widget 99 1 15-JAN-03 Product 1 50 100 15-JAN-03 2 rows selected. SQL> SQL> SELECT * FROM product WHERE quantity_on_hand < 1000; PRODUCT_NAME PRODUCT_PRICE QUANTITY_ON_HAND LAST_STOC ------------------------- ------------- ---------------- --------- Small Widget 99 1 15-JAN-03 Product 1 50 100 15-JAN-03 2 rows selected. SQL> SQL> SELECT * FROM product WHERE quantity_on_hand <= 1000; PRODUCT_NAME PRODUCT_PRICE QUANTITY_ON_HAND LAST_STOC ------------------------- ------------- ---------------- --------- Small Widget 99 1 15-JAN-03 Widget 75 1000 15-JAN-02 Product 1 50 100 15-JAN-03 3 rows selected. SQL> SQL> SELECT * FROM product WHERE quantity_on_hand > 1000; PRODUCT_NAME PRODUCT_PRICE QUANTITY_ON_HAND LAST_STOC ------------------------- ------------- ---------------- --------- Product 2 25 10000 1 row selected. SQL> SQL> SELECT * FROM product WHERE quantity_on_hand >= 1000; PRODUCT_NAME PRODUCT_PRICE QUANTITY_ON_HAND LAST_STOC ------------------------- ------------- ---------------- --------- Widget 75 1000 15-JAN-02 Product 2 25 10000 2 rows selected. SQL> SQL> SELECT * FROM product WHERE quantity_on_hand > 1000; PRODUCT_NAME PRODUCT_PRICE QUANTITY_ON_HAND LAST_STOC ------------------------- ------------- ---------------- --------- Product 2 25 10000 1 row selected. SQL> SQL> SELECT * FROM product WHERE quantity_on_hand >= 1000; PRODUCT_NAME PRODUCT_PRICE QUANTITY_ON_HAND LAST_STOC ------------------------- ------------- ---------------- --------- Widget 75 1000 15-JAN-02 Product 2 25 10000 2 rows selected. SQL> SQL> SELECT * FROM product WHERE product_price IN (50, 99); PRODUCT_NAME PRODUCT_PRICE QUANTITY_ON_HAND LAST_STOC ------------------------- ------------- ---------------- --------- Small Widget 99 1 15-JAN-03 Product 1 50 100 15-JAN-03 2 rows selected. SQL> SQL> SELECT * FROM product ORDER BY product_price DESC; PRODUCT_NAME PRODUCT_PRICE QUANTITY_ON_HAND LAST_STOC ------------------------- ------------- ---------------- --------- Small Widget 99 1 15-JAN-03 Widget 75 1000 15-JAN-02 Product 1 50 100 15-JAN-03 Product 2 25 10000 4 rows selected. SQL> SQL> DROP TABLE product; Table dropped. SQL>