Actually... with that requirement, I wonder if it's even easier/better to use:
Select name, min(setid), hash >From rtable Group by name, hash Having min(setid) > 0 -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Paul Sanderson Sent: Thursday, January 31, 2013 5:08 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQL query Cool that seems to work - thanks _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users