MySQL 5.7.5 이하 버전에 Group by 절 이 외 컬럼 조회 가능.
https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html
MySQL :: MySQL 5.7 Reference Manual :: 12.20.3 MySQL Handling of GROUP BY
12.20.3 MySQL Handling of GROUP BY SQL-92 and earlier does not permit queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are not named in the GROUP BY clause. For example, this query is illegal in stan
dev.mysql.com
'Routine > Database' 카테고리의 다른 글
| [mongodb]리스트내 특정 텍스트 검색 (0) | 2020.02.02 |
|---|---|
| MySQL 정렬 처리 방식 (0) | 2020.02.02 |
| Useful PostgreSQL Query (0) | 2020.02.02 |
| Mysql 사용자 추가 (0) | 2020.02.02 |