How to output only 1 if data same [closed]

You can make your query like this for getting same result that you want –

SELECT SUM(Total) as total,Name from table_name group by Name;