Oracle/MySQL °ü·Ã °Ô½ÃÆÇ |
---|
2015/01/11(22:12) from 58.125.30.140 | |
ÀÛ¼ºÀÚ : ÁÖÀÎÀå | Á¶È¸¼ö : 2795 , ÁÙ¼ö : 8 |
Re: [Oracle] rownumÀ» »ç¿ëÇؼ MySQLÀÇ limit Èä³»³»±â (ÀÌ°Å Âü°í 1) |
---|
select * FROM ( select rownum as rn , table_name.* FROM table_name ) WHERE rn BETWEEN 1 AND 5; |