보여주고자하는 쿼리문에 lmit (숫자); 만 걸어주면 해당 갯수가 나옴
select * from board
where board_deletion="N" and board_type!="CS" and board_secret = "N"
order by board_view desc limit 5;
select * from comment
join board on board_id = board_comment_id
where comment_deletion="N" and board_deletion="N"
order by comment_datetime desc limit 5;
'괴발개발 > Spring Framework' 카테고리의 다른 글
DB_cursor 커서(delimiter) (0) | 2021.10.06 |
---|---|
에러: chart with id '0' must be destroyed, chart is reused (0) | 2021.10.06 |
DB_최고MAX,최저MIN 카운트COUNT 구하기 (0) | 2021.10.01 |
forfree메모 (0) | 2021.10.01 |
브라우저에 스크롤 만들기 (0) | 2021.10.01 |