List:General Discussion« Previous MessageNext Message »
From:ViSolve DB Team Date:January 5 2007 4:39am
Subject:Re: mysql question regarding distinct/group by...
View as plain text  
Hi,
> 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
>
Try,

select * from dog where fooID=1 group by fooID;

- which retrieves the first instance;
resulting in,

1,2,1

Thanks
ViSolve DB Team

----- Original Message ----- 
From: "bruce" <bedouglas@stripped>
To: <mysql@stripped>
Sent: Thursday, January 04, 2007 6:07 AM
Subject: mysql question regarding distinct/group by...


> 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...
>
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>

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