Usuario nuevo
Hola, soy usuario nuevo y tengo problemas con el comando Group by.
Al utilizar el siguiente comando en un pc funciona correctamente pero al utilizar en otra pc me visualiza un error.
SELECT *
FROM film
GROUP BY replacement_cost;
Error Code: 1055. Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sakila.film.film_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
agradezco su gentil ayuda con este problema.
Saludos
Subject
Views
Written By
Posted
Usuario nuevo
436
June 27, 2023 04:32PM
100
June 04, 2024 07:02AM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.