Martin Engelschalk <[EMAIL PROTECTED]> wrote: > Hi, > > let the table have two columns, "a" and "b". Then > > select a, count(b) > from yourtable > group by a > having count(b) > 1 > > returns 'fred' and 'roger'.
No it doesn't. It returns an empty set. Try it. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
