MrTV
asked on
sql in mysql to select data
The data is like in picture but I want to make report like this How can I do it with sql state ment (mysql)
pin pfi ppr
David 200 100 500
Robert 40 0 260
Jhon 270 180 30
viilage.JPG
pin pfi ppr
David 200 100 500
Robert 40 0 260
Jhon 270 180 30
viilage.JPG
I don't see relevance of the supplied data with the required output! Are you sure you have attached the right data-set ?
ASKER
excuseme the picture is not corect the corec is
table.JPG
table.JPG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
from table name
group by (useranamefield)