"Alexey V. Litvinov" wrote:
>
> Hello JCampell,
>
> Friday, December 22, 2000, 11:25:51 AM, you wrote:
>
> RTFM about SELECT and about DISTINCT option
>
> J> I want to know if it is possible to build a MySQL query which will only
> J> return the unique values of a specific column. Ie if I had
Hello JCampell,
Friday, December 22, 2000, 11:25:51 AM, you wrote:
RTFM about SELECT and about DISTINCT option
J> I want to know if it is possible to build a MySQL query which will only
J> return the unique values of a specific column. Ie if I had this table:
J> id | name |date___
J> 1 |
I want to know if it is possible to build a MySQL query which will only
return the unique values of a specific column. Ie if I had this table:
id | name |date___
1 | Jon | 2001-01-03
2 | Bob | 2001-01-04
3 | Jon | 2001-01-05
Is there any SQL query that will only return 1 row for each