I have a table where I need to select all distinct records from two columns and include a third that varies. It is possible that for multiple records where the first and second columns are equivalent, the third varies so it cannot be used in the distinct clause. In this case, I want to select the third column in the first record and ignore the remaining to append to the final result.
For example: colA | colB | colC ----------------------- aaa | bbb | lorem ipsum aaa | bbb | lorem ipsum dolar aaa | ccc | foo bar This should only return the first and third row. How do you do this in SQLite? Thanks, jlc _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
