Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>>1.- Select city,date,Max(temp) from yourtable order by city group by city,date
>>>
>>
>>This select would return date from last physical record for each city not date corresponded to Max(temp).
>
>No. This SQL statement would return the maximum temp recorded for each city for each day. If you only had 1 recorded temp per day, it would return all records in the table.
Actually that worked pretty well. I thank everyone for their input, I now know what to read up on again (group by & max) I think my brief description was interpreted in different ways by different people. Just to recap, I did want only the all time high for each city.
This statement got me 6 records back for my 6 cities I tested with. (no matter how many entries per day, and even if the high-temp was duplicated.)
SELECT City.*, Temperature.ddate, MAX( Temperature.nhightemp);
FROM keycust!city INNER JOIN keycust!temperature ;
ON City.icityid = Temperature.icityid;
GROUP BY City.ccityname;
ORDER BY City.ccityname
Précédent
Suivant
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