Looking for Complex Queries.

From: Russell P. Starksen <rps_at_cray.com>
Date: 7 Sep 93 03:56:37 CDT
Message-ID: <1993Sep7.035647.10111_at_walter.cray.com>


Hi,

   I'm looking for some examples of complex queries that people are using out there. In particular those that use mathmatical functions.

EXAMPLE:

        Select patient, patient_home_phone where Blood_sugar > 20, Pulse
        < 80 and temperature < 99 and illness %LIKE% headache and 
        (f1 * f3) / f4  > f2 and (TAN f5) = f6 and year = 1991 and
        month = 'MAY' and day = '13';

Thanks!
  __
  /_) _ _
 / \_/_/_/_)_/_)_

 Russ Starksen                              Phone#: (612) 683-3635
 Cray Research Inc.                         FAX#: (612) 683-3699
 655E Lone Oak Drive                        E-mail: rps_at_cray.com
 Eagan, Mn. 55121 Received on Tue Sep 07 1993 - 10:56:37 CEST

Original text of this message