Город МОСКОВСКИЙ
00:01:48

ORA-00979: not a GROUP BY expression - Oracle Database 12c Error Messages

Аватар
Кодерское обновление
Просмотры:
21
Дата загрузки:
05.12.2023 10:02
Длительность:
00:01:48
Категория:
Технологии и интернет

Описание

In this video we are going to see how to fix below Oracle Database 12c Error Message.

ORA-00979: not a GROUP BY expression.
Cause: The GROUP BY clause does not contain all the expressions in the SELECT clause.
SELECT expressions that are not included in a group function, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or VARIANCE, must be listed in the GROUP BY clause.
Action: Include in the GROUP BY clause all SELECT expressions that are not group function arguments.

#12c #oracledatabase12c #oracledatabase #oracledba #sql #oraclesql #oraerrors #oracleerrorcodes #dba #database

Рекомендуемые видео