I have table revaluation_of_table with unique constraint (item,date,sales_category). I have to update or insert data from stock_revaluation table. So I tried these code.
select item,date,sales_category from arpan.stock_revaluation
group by item,date,sales_category
having count(item)>1
This...