Frank Missel <i...@missel.sg> wrote: >> SQLite allows this as an extension. When this happens, a value from an >> arbitrary row within the group is reported. This is often convenient. >> > Ha ha, you must be joking, right? > Otherwise, you must enlighten me on how it could have a practical use to > have an arbitrary value in the group returned together with the total number > of records across all the groups.
It's not useful in your specific query, but it is useful in others. Yours is not the only system in the world that uses SQLite, you know. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users