SQL
MySQL / Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column '컬럼명' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
MySQL에서 GROUP BY 로 한 컬럼을 기준으로 오름차순으로 정렬하고 중복제거 후 하나의 row를 조회하려고 하는데 다음과 같이 error가 발생할 수 있는데, Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column '컬럼명' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by SELECT update_flag, update_detail, create_date FROM BOARD_RECORD WHERE ..
2023. 2. 4. 13:26
최근댓글