Oracle/MySQL °ü·Ã °Ô½ÃÆÇ |
---|
2018/05/22(10:37) from 211.209.26.174 | |
ÀÛ¼ºÀÚ : ÁÖÀÎÀå | Á¶È¸¼ö : 7771 , ÁÙ¼ö : 16 |
Re: [Oracle] rownumÀ» »ç¿ëÇؼ MySQLÀÇ limit Èä³»³»±â (ÀÌ°Å Âü°í 2) |
---|
SELECT * FROM ( SELECT rownum AS rn, COUNT(*) OVER() AS totalCnt, A.* FROM ( SELECT * FROM persons ORDER BY id ) A ) <if test="start != null and end != null"> WHERE rn BETWEEN #{start} AND #{end} |