>Hi all, I want to select the records If result"Fail" is repeated 3 time .
>thanks
>SELECT * FROM examtran WHERE code="001724" AND year=2008 AND result="Fail" GROUP BY nmonth,result
Your question is not clear, Fail 3 times per Code? Or Fail 3 times per code, year? Anyway assuming per Code.
SELECT * FROM examtran WHERE code in ;
(SELECT code FROM examtran where result=="Fail" having count(*) >= 3 GROUP BY code)
Cetin