MySQL에서 rownum 구현....

http://blog.naver.com/reomereome/40051397806

 SELECT @ROWNUM:=@ROWNUM+1 AS NO, AA.필드명1, AA.필드명2
 FROM (SELECT 필드명1, 필드명2 FROM 테이블명 WHERE 조건절 ORDER BY 정렬필드 ASC) AA, (SELECT @ROWNUM:=0) R