I have a query that gives me a desired result of 700 records. The query is being run on a table:
SELECT Min(my.number) AS numberOfMin, my.hello, my.boy, my.girl, my.truck, my.kid, my.mom, my.dad, my.man, my.woman, my.duck, my.goose, my.cat
FROM my
GROUP BY my.hello, my.boy, my.girl, my.truck, my.kid, my.mom, my.dad, my.man, my.woman, my.duck, my.goose, my.cat;
If, however, I add one more column (added at end of query - my.dog), I get one more record returned in my output than desired (a result of 701 records):
SELECT Min(my.number) AS numberOfMin, my.hello, my.boy, my.girl, my.truck, my.kid, my.mom, my.dad, my.man, my.woman, my.duck, my.goose, my.cat, my.dog
FROM my
GROUP BY my.hello, my.boy, my.girl, my.truck, my.kid, my.mom, my.dad, my.man, my.woman, my.duck, my.goose, my.cat, my.dog;
If I add the remaing columns in the table, I get even more results (records)
What is going on here? I am baffled. . . The results just go up as I add more columns