On 15-Sep-2011, at 2:55 AM, Magnus Thor Torfason wrote:

> 
> I then ran a query grouping employees by job:
> 
>  > select ename, job from emp group by job;
>  "ENAME", "JOB"
>  ==============
>  "FORD", "ANALYST"
>  "MILLER", "CLERK"
>  "CLARK", "MANAGER"
>  "KING", "PRESIDENT"
>  "TURNER", "SALESMAN"
> 
> Now, I get a list of the jobs, and a random selection of employees. I would 
> have expected an error here. Of course, my actual 

It's not random selection, it's the last one from the list.

-radzi-
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to