Re: Quick MySql Question

SELECT make FROM table GROUP BY make Does the job. If you have multiple colums, IE Make, Year you can do.. SELECT * FROM table GROUP BY make, year "Taylor York" <taylor@dreamstargroup.com> wrote in message news:20021021222348.91182.qmail@pb1.pair.com... > Hello, basically, I want a select with no duplicates... > I have a table similar to: > +----+--------+--------+ > | id | model | make | > +----+--------+--------+ > | 1 | Supra | Toyota | > +----+--------+--------+ > | 2 | Civic | Honda | > +----+--------+--------+ > | 3 | Celica | Toyota | > +----+--------+--------+ > | 4 | Accord | Honda | > +----+--------+--------+ > > If I do a " SELECT make FROM table " I will get 2 > toyotas, and 2 hondas, > But what I want is just 1 toyota, and 1 honda. > > Any suggestions? > > > > >