Re: newbie: how to return one iteration *per unique date (DAY!)* in a timestamp column?
| From: | Govinda | Date: | Wed, 05 Aug 2009 14:01:29 +0000 |
| Subject: | Re: newbie: how to return one iteration *per unique date (DAY!)* in a timestamp column? | ||
| References: | 1 2 3 4 5 6 7 8 9 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-46415@lists.php.net to get a copy of this message | ||
Just one other tiny point of style here: having given the expression date(solarAWDateTime) the alias uniqueDate, you should probably use that alias to refer to the same thing elsewhere in your query, such as in the GROUP BY column. So: ... That's how I'd write it, anyway.I like to know your thinking; I'm working to learn to 'think in MySQL'.. so every input is appreciated. thanks! -G