Re: HELP...Learning SQL
From: David <ds_at_netvigator.com>
Date: 1996/08/16
Message-ID: <01bb8b8c$51518580$LocalHost_at_ds>#1/1
Date: 1996/08/16
Message-ID: <01bb8b8c$51518580$LocalHost_at_ds>#1/1
select count(*), class, student
from basetable
group by class, student
having count(*) < 5;
vikram.karmarkar_at_internetMCI.com wrote in article
<4ulp3r$fee_at_news.internetmci.com>...
> Here's the scenario:
> Each student is supposed to turn in 5 assignments(1 thru' 5 "assn_num"s)
> I have to create a report showing a list of "assn_num" missing
> for all the students who have not turned in all five assignments.
Received on Fri Aug 16 1996 - 00:00:00 CEST