On Mon, Aug 6, 2012 at 2:58 PM, Tilsley, Jerry M. <[email protected]>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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
