MySQL Forums
Forum List  »  Spanish

Usuario nuevo
Posted by: Luis Alberto
Date: June 27, 2023 04:32PM

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

Options: ReplyQuote


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.