String board_list_sql="select * from "+
"(select rownum rnum,BOARD_NUM,BOARD_ID,BOARD_SUBJECT,"+
"BOARD_CONTENT,BOARD_FILE,BOARD_RE_REF,BOARD_RE_LEV,"+
"BOARD_RE_SEQ,BOARD_READCOUNT,BOARD_DATE from "+
"(select * from memberboard order by "+
"BOARD_RE_REF desc,BOARD_RE_SEQ asc)) "+
"where rnum>=? and rnum<=?";
고수님들..
이 문장을 mysql의 limit로 바꾸려면 어떻게 해야 할까요..
|