Query 읽기

HyL·2023년 4월 18일
0
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;

쿼리 읽는방법

0개의 댓글