General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>Larry is not saying that you will get the wrong temperature for each city; he is saying that your query will tell you the wrong DATE for that temperature. Just looking at your query, I would think the date would be incorrect, unless
You're right. I was home last night thinking about this problem, trying to figure out why it seemed like I got the right answer, but wasn't suppose to. Then it hit me, that I'm getting the right temp (after all, max(temp))
but getting the wrong record back. Two very distinct things! And that just won't do!
Nice catch, thanks for the help,
Dustin
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only