On Mon, Aug 6, 2012 at 2:58 PM, Tilsley, Jerry M. <jmtils...@st-claire.org>wrote:
> Guys, > > I'm sure this is a pretty lame question, but my thinking hat is > malfunctioning this morning. How can I select all rows from a table where > a specific column is NOT UNIQUE? Table has three columns (charge_code, > mnemonic, description). > > SELECT * FROM tablename WHERE charge_code IN (SELECT charge_code FROM tablename GROUP BY description HAVING Count(*)>1) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users