Tag: sql

SQL: Counting duplicate fields

Group all the records by the smiles column, count the number of occurrences for each unique SMILES string, and then filter the results to show only those strings that appear more than once… Show how many records in total exist in your table and then subtracts the number of unique SMILES strings. The result is…

Read the full article

"Walter, you're not wrong, you're just an asshole!"