select * from(
       SELECT
        row_number()OVER( order by a.regDate DESC ) as rownum
       , a.*
       FROM koman_board AS a
where board='video' and title<>''
) as xxx where xxx.rownum BETWEEN 1 AND 20

검색