Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select Query Help
Message
From
25/12/2016 00:41:53
Mazahir Naya
Pixel Digital Systems LLC
United Arab Emirates
 
 
To
All
General information
Forum:
Oracle
Category:
PL/SQL
Title:
Select Query Help
Miscellaneous
Thread ID:
01646039
Message ID:
01646039
Views:
33
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
Next
Reply
Map
View

Click here to load this message in the networking platform