Minus in select : Select « Select Query « Oracle PL / SQL

1. Oracle PL / SQL
2. Select Query
3. Select

Minus in select

   
SQL>
SQL> CREATE TABLE purchase (
  2       product_name  VARCHAR2(25),
  3       product_price NUMBER(4,2),
  4       sales_tax     NUMBER(4,2),
  5       purchase_date DATE,
  6       salesperson   VARCHAR2(3));

Table created.

SQL>
SQL> INSERT INTO purchase VALUES ('Product Name 1', 1, .08, '5-NOV-00', 'AB');

1 row created.

SQL> INSERT INTO purchase VALUES ('Product Name 2', 2.5, .21, '29-JUN-01', 'CD');

1 row created.

SQL> INSERT INTO purchase VALUES ('Product Name 3', 50.75, 4.19, '10-DEC-02', 'EF');

1 row created.

SQL> INSERT INTO purchase VALUES ('Product Name 4', 99.99, 8.25, '31-AUG-03', 'GH');

1 row created.

SQL>
SQL>
SQL> SELECT product_name, 100 - product_price FROM purchase;

PRODUCT_NAME              100-PRODUCT_PRICE
------------------------- -----------------
Product Name 1                           99
Product Name 2                         97.5
Product Name 3                        49.25
Product Name 4                          .01

4 rows selected.

SQL>
SQL>
SQL> DROP TABLE purchase;

Table dropped.

SQL>
SQL>
SQL>

   
    
  

Related examples in the same category