select seq,nickname,title,content
from
(
select rownum as rnum ,A.seq, A.nickname, A.title, A.content
from
(
select seq,nickname,title,content
from board
where type = 1
and nickname like '%kk%'
order by seq desc
) A
)
where rnum > 0 and rnum <= 4;
쿼리 읽는방법