Re: Looking only for uniqueness

2001-03-19 Thread Steve Ruby
"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

Re: Looking only for uniqueness

2001-03-19 Thread Alexey V. Litvinov
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 |

Looking only for uniqueness

2001-03-17 Thread JCampell
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