If you have scraped data on more than one occasion and want to check if a value has changed in a column since the previous scrape you could use this: select col1, col2  from TABLENAME  group by col1, col2  having count(col2) <2 This will compare and check if a value for col2 has changed since the previous scrape Let’s put some real names […]