Hello universal Team
i am not much advance in writing MS-SQL Query help me to get following output from the table.

i have following information in my Table

Company Code| Name | Email
001 | ABC | ABC@123.com
001 | ABC | EFG@123.com
001 | ABC | EFG@123.com
002 | AAABBBCCC | maza@gmail.com
002 | AAABBBCCC | Maza.Naya@gmai.com

Query Out Put Need:

Company Code | Name | Email
001 | ABC | ABC@123.com; EFG@123.com; EFG@123.com
002 | AAABBBCCC | maza@gmail.com;Maza.Naya@gmai.com

Thanks in Advance.
Best Regards,
Mazahir Naya