Seleting records
| From: | Simon Allison | Date: | Thu, 17 Mar 2005 04:18:03 +0000 |
| Subject: | Seleting records | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-210932@lists.php.net to get a copy of this message | ||
Hello,
My news table has a year field as such
Year
--------
2000
2000
2001
2001
2003
2005
2005
I was wondering if you could select from this table so you only get one of
each year, so the output would be
2000
2001
2003
2005
Is this possible, I was trying to think of an algorithm that would work, but
I have had no luck yet?
Thanks,
Simon