sql - How to select the sum of distinct values in a table using mysql -
slno state district company 1 ab abc 2 ab ac 3 ab abc 4 ab abc 5 ab abc 6 ab ac output state district company sumzz ab abc 4 ab ac 2 what have tried select state,district,company,sum(company) sumzz company how achieve display last row based on distinct company? and what's wrong approach: select state, district, company, count(*) countzz company group state, district, company