MySQL Forums
Forum List  »  General

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


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


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!


Options: ReplyQuote

Written By
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.