Oracle/MySQL °ü·Ã °Ô½ÃÆÇ |
---|
2018/05/22(10:57) from 211.209.26.174 | |
ÀÛ¼ºÀÚ : ÁÖÀÎÀå | Á¶È¸¼ö : 2275 , ÁÙ¼ö : 9 |
Re: [Oracle] rownumÀ» »ç¿ëÇؼ MySQLÀÇ limit Èä³»³»±â (ÀÌ°Å Âü°í 3) |
---|
@row_number() over()¸¦ È°¿ëÇÑ ´Ù¸¥ ¹æ¹ý SELECT * FROM ( SELECT a.*, row_number() over(order by id) as num FROM persons a ) WHERE num BETWEEN 1 AND 5 |