Find student whose attendence is less than 75% in subject AC?
select k.studentID, k.PercentageAttd
select a.STUDENTNO as studentID,
(select count(PRESENCE_K)*100 from attendence b1 where b1.PRESENCE_K='P' and STUDENTNO=a.STUDENTNO and subject_k = 'AC')/
(select count(PRESENCE_K) from attendence b2 where STUDENTNO=a.STUDENTNO and subject_k = 'AC') as PercentageAttd
from attendence a) k
June 23, 2007 2:36 AM
June 23, 2007 7:40 AM