Path: utzoo!attcan!uunet!mcsun!hp4nl!svin02!wsinpdb
From: wsinpdb@svin02.info.win.tue.nl (Paul de Bra)
Newsgroups: comp.databases
Subject: Re: SQL Question
Keywords: SQL
Message-ID: <1472@svin02.info.win.tue.nl>
Date: 11 Oct 90 11:55:48 GMT
References: <391@ulticorp.UUCP> <1090@lsicom2.UU.NET> <1990Oct10.121246.8576@oracle.com>
Organization: Eindhoven University of Technology, The Netherlands
Lines: 14

In article <1990Oct10.121246.8576@oracle.com> dkennedy@oracle.UUCP (DAN KENNEDY) writes:
>In article <1090@lsicom2.UU.NET> root@lsicom2.UU.NET (Admin) writes:
>>
>>>Given a table of patients PID int   WEIGHT int
>>>where one PID may have numerous weight readings.
>... [ answers with subqueries deleted ]

how bout

select pid from table
group by pid
having min(weight) < 100

Paul.
(debra@research.att.com)