Hi all I am trying to create a query that works to craete a subset of a table based on duplicate items
Examples work best so consider the contrived table with the following rows 10 socata 7 socata 13 cessna 2 piper 7 piper 55 piper 1 diamond I want to see the subset that is 10 socata 7 socata 2 piper 7 piper 55 piper i.e. all rows that have a matching value in any other row in the second column any ideas? _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
