SELECT * FROM Dog GROUP BY FooId HAVING FooId = 1;
This should also work.
On 1/5/07, ViSolve DB Team <[EMAIL PROTECTED]> wrote:
Hi,
> dog
> fooID int
> size int
> id int
>
> dog
> fooIDsizeid
>1 2 1
>2 5 2
>1 5 3
>
> if i do a query
> sel
Hi,
dog
fooID int
size int
id int
dog
fooIDsizeid
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;
resulti
In the last episode (Jan 03), bruce said:
> 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
> fooIDsizeid
> 1 2 1
> 2
