java) row_number()over, partition, substr, order by
row_number()over, partition, substr, order by 오늘 배운 생소한 개념들을 예제로 설명하겠습니다. 일정관리- CalendarDao.java 의 코드 String sql = "select seq, id, title, content, rdate, wdate" + " from" + " (select row_number()over(partition by substr(rdate, 1, 8) order by rdate asc) as rnum," + " seq, id, title, content, rdate, wdate" + " from calendar" + " where id=? and substr(rdate, 1, 6) =?) a " // ?에 id, yyyyMM 들어감 + " ..
2023. 2. 17.