selecting values from column without repeating
| From: | sarahana | Date: | Fri, 19 Jan 2001 03:41:47 +0000 |
| Subject: | selecting values from column without repeating | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-5966@lists.php.net to get a copy of this message | ||
Hello,
I was wondering if it would be possible to select values from a column (lets say the column
"year") so that each value gets retrieved only once... for example, there are multiple
rows in a table - some with '2001' as the value for the year column, and some with
'2000'. Now, what I wanted to do is list the values of the year so that 2001 shows up only
once, and 2000 shows up only once without repeating... is this possible?
thanks.