home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a079 / 1.img / FPDG.LZH / VOL2NUM0 / MISC / SALESMAN.PRG < prev    next >
Encoding:
Text File  |  1993-02-01  |  820 b   |  15 lines
  1. *****************************************************************
  2. *     * 09/92               SALESMAN.PRG                        *
  3. *****************************************************************
  4. *     * Author's Name: Jeb Long                                 *
  5. *     *                                                         *
  6. *     * Description:                                            *
  7. *     * This program illustrates how to use the SQL SELECT      *
  8. *     * command using a filter that displays "Salesmen" that    *
  9. *     * make more than a company vice president.                *
  10. *****************************************************************
  11. SELECT * FROM Employee e ;
  12.   WHERE e.position = 'Salesman' AND ;
  13.    e.salary > ALL (SELECT f.salary FROM Employee f;
  14.    WHERE f.position = 'VP')
  15.