MySQL Forums
Forum List  »  Analytics, Reporting, BI

matrix sql query
Posted by: Ferdie Palero
Date: June 18, 2019 07:38PM

Hi,

Anyone can help on how can I query using SQL statement;

Input

name privileges
---- ----------
tim, read
tim, delete
tim, write
tim, update
ben, read
ben, write
ben, update
..
..
..

Output needed using SQL

name privileges
---- ----------
tim read,delete,write,update
ben read,write,update
..
..

Thanks in advance!

Regards,
FSPalero

Options: ReplyQuote


Subject
Written By
Posted
matrix sql query
June 18, 2019 07:38PM
June 18, 2020 10:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.