On 9/14/2011 2:55 PM, 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.
It's a SQLite-specific extension. Very useful in certain cases.
So getting an explicit error here
would have made things simpler.
Is there a way to do that?
None that I know of.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
