If I wanted to find all the unique_tag_no that have duplicates (which they shouldn't) in the inventory qty detail table. 


Select unique_tag_no, count(unique_tag_no) from inventory_qty_detail group by unique_tag_no having count(unique_tag_no)>1