Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
I was responding to the issue which our friend posted.
As you're aware, when a SQL aggregating function is used on one field of a SELECT, all other fields in the result set must either be couched in an aggregating function or be included in the GROUP BY clause for the values to be meaningful. Fields not handled in this way return results which are implementation dependant -- in otherwords, not meaningful. This explains the situation our friend ran into of data combined between records.
Since your example only returns 1 field -- that couched in a MIN -- it will return meaningful results.
Jay
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement