Hola equipo. Las últimas instrucciones no funcionan en mi workbench. La quiery. SELECT CIUDAD, BARRIO, MAX(LIMITE_DE_CREDITO) AS LIMITE FROM tabla_de_clientes GROUP BY ESTADO, BARRIO; Este es el error. 09:33:03 SELECT CIUDAD, BARRIO, MAX(LIMITE_DE_CREDITO) AS LIMITE FROM tabla_de_clientes GROUP BY ESTADO, BARRIO LIMIT 0, 1000 Error Code: 1055. Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'jugos_ventas.tabla_de_clientes.CIUDAD' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 0.00080 sec
Esta otr tampoco funciona. SELECT ESTADO, BARRIO, MAX(LIMITE_DE_CREDITO) AS LIMITE, EDAD FROM tabla_de_clientes WHERE EDAD >=20 GROUP BY ESTADO, BARRIO ORDER BY EDAD;
Este es el Error: 09:34:05 SELECT ESTADO, BARRIO, MAX(LIMITE_DE_CREDITO) AS LIMITE, EDAD FROM tabla_de_clientes WHERE EDAD >=20 GROUP BY ESTADO, BARRIO ORDER BY EDAD LIMIT 0, 1000 Error Code: 1055. Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'jugos_ventas.tabla_de_clientes.EDAD' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 0.00088 sec
Gracias de antemano.
Me pueden para el discord de alumnos regulares de alura?
