>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