How do I combine rows in sql query and remove duplicates
SELECT `Name`
     , `Account Number`
     , MAX(`Accout Role 1`) `Accout Role 1`
     , MAX(`Account Role 2`) `Accout Role 2`
FROM MyTable
GROUP BY `Account Number` -- , `Name`