I have a situation where I need to select entries based on the count of the number of entries in a GROUP = 2, and also that the value of a specific column must be different for each row in the group. I then need to select all the individual rows from the qualifying groups.
Getting the groups with count=2 is pretty straightforward: SELECT * FROM TableA GROUP BY z HAVING count(*)=2; Is there a format that will allow me to have the same SELECT statement return the individual rows from each qualifying group that have a different value in a specific column or is this something I should do in my application logic? The value of 'z' in the above example could be used to select the individual rows and there are other columns in the table that could be used in a JOIN statement to link the table to itself. Thanks, Pete lcSQL Software <http://www.lcsql.com> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
