List:General Discussion« Previous MessageNext Message »
From:bruce Date:January 4 2007 12:37am
Subject:mysql question regarding distinct/group by...
View as plain text  
hi...

i've asked something similar before.. but it appears something is going
wrong... so, back to basics...

i have the following test tbl.

dog
 fooID int
 size int
 id int

dog
  fooID    size    id
    1       2      1
    2       5      2
    1       5      3

if i do a query
  select * from dog where fooID='1';

  i get
  1,2,1
  1,5,3

how can i do a distinct/group by select such that if i do a select on
fooID=1, i'll only get '1,2,1', or '1,5,3', meaning that i don't get both of
the items where fooId=1.

thanks...


Thread
mysql question regarding distinct/group by...bruce4 Jan
  • Re: mysql question regarding distinct/group by...Dan Nelson4 Jan
  • Re: mysql question regarding distinct/group by...ViSolve DB Team5 Jan
    • Re: mysql question regarding distinct/group by...Arun Kumar PG5 Jan