Skip to main content

Return to Question

Formatting code
Source Link
Eric Brandt
Eric Brandt
  • 8.1k
  • 3
  • 20
  • 39

i'm struggleI'm struggling with this sqlSQL consult, the error message is: 1055 - Expression #10 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ctrl2019.s.cgsc_cuenta' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by. And

1055 - Expression #10 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ctrl2019.s.cgsc_cuenta' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by.

And here is the code:

i'm struggle with this sql consult, the error message is: 1055 - Expression #10 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ctrl2019.s.cgsc_cuenta' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by. And here is the code:

I'm struggling with this SQL consult, the error message is:

1055 - Expression #10 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ctrl2019.s.cgsc_cuenta' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by.

And here is the code:

Source Link
JUAN GB
JUAN GB
  • 3
  • 2

Error 1055 SQL - SELECT list is not in GROUP BY

i'm struggle with this sql consult, the error message is: 1055 - Expression #10 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ctrl2019.s.cgsc_cuenta' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by. And here is the code:

SELECT c.cgcu_cuenta AS id, g.ger_cuenta, g.ger_nombre, p.cgp_cuenta, p.cgp_nombre, r.rub_cuenta, r.rub_nombre, c.cgcu_cuenta, c.cgcu_nombre, s.cgsc_cuenta, s.cgsc_nombre, SUM(IFNULL(a.debe, 0)) - SUM(IFNULL(a.haber, 0)) AS debe, 0 AS haber, 'D' AS nat_id, c.cgcu_cuenta AS cuenta, c.cgcu_nombre AS nombre FROM ctrl2019.cat_Genero g INNER JOIN ctrl2019.cat_CgGrupo p USING(ger_id) INNER JOIN ctrl2019.cat_Rubro r USING(ger_id, cgp_id) INNER JOIN ctrl2019.cat_CgCuenta c USING(ger_id, cgp_id, rub_id) INNER JOIN ctrl2019.cat_CgSubcuenta s USING(ger_id, cgp_id, rub_id, cgcu_id) LEFT JOIN ( SELECT a.ger_id, a.grp_id, a.rub_id, a.cta_id, a.sct_id, SUM(IFNULL(a.msl_debe, 0)) AS debe, SUM(IFNULL(a.msl_haber, 0)) AS haber FROM ldf.vin_EntePublicoLDF e INNER JOIN ldf.blz_Mensual_2019 a USING(gpo_id, ur_id) WHERE e.ejr_id = 2019 AND a.ger_id = 1 AND e.ent_id = 12 AND a.msc_id IN (0, 1, 2, 3) GROUP BY a.ger_id, a.grp_id, a.rub_id, a.cta_id, a.sct_id )a ON s.ger_id = a.ger_id AND s.cgp_id = a.grp_id AND s.rub_id = a.rub_id AND s.cgcu_id = a.cta_id AND s.cgsc_id = a.sct_id WHERE g.ger_id = 1 GROUP BY g.ger_id, p.cgp_id, r.rub_id, c.cgcu_id;

I have no idea why it gives me this error, i'm new in sql.