RE: [PHP-DB] newbie: how to return one iteration *per unique date (DAY!)* in a timestamp column?
| From: | Ford, Mike | Date: | Wed, 05 Aug 2009 11:28:00 +0000 |
| Subject: | RE: [PHP-DB] newbie: how to return one iteration *per unique date (DAY!)* in a timestamp column? | ||
| References: | 1 2 3 4 5 6 7 8 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-46414@lists.php.net to get a copy of this message | ||
> -----Original Message-----
> From: Govinda [mailto:govinda.webdnatalk@gmail.com]
> Sent: 05 August 2009 01:41
>
> > Taking this:
> > SELECT count(*) AS
> >
CountUniqueDatesInMyTbl, date(solarAWDateTime) AS
> > uniqueDate,
> > 'aweber_7solar_aw' AS tableAlias FROM
> > aweber_7solar_aw GROUP BY
> > DATE(solarAWDateTime)
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:
SELECT count(*) AS CountUniqueDatesInMyTbl,
date(solarAWDateTime) AS uniqueDate,
'aweber_7solar_aw' AS tableAlias
FROM aweber_7solar_aw
GROUP BY uniqueDate;
That's how I'd write it, anyway.
Cheers!
Mike
--
Mike Ford,
Electronic Information Developer, Libraries and Learning Innovation,
Leeds Metropolitan University, C507, Civic Quarter Campus,
Woodhouse Lane, LEEDS, LS1 3HE, United Kingdom
Email: m.ford@leedsmet.ac.uk
Tel: +44 113 812 4730
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm