Check LISTAGG() function.

MartinaJ

>Hello universal Team
>i am not much advance in writing Oracle 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