Hi all,
Is it possible to query data in MySQL database and group the data based from saved categories? Let's say I have categories Programmer, Accountant, Sales & Marketing, Technical. Data on each categories are dynamic can be how many user inserted. So, I want to do a query which will conclude as below:-
Data in database:-
ID|Name|Position|Date Joined
==================
112435|Micheal Angelo|Accountant|01-02-2015
520643|John Abraham|Sales & Marketing|15-06-2014
235648|Jonathan James|Programmer|11-03-2013
113254|Adam Sandler|Accountant|03-02-2015
526987|Johnny|Sales & Marketing|10-07-2014
231564|Adrian Lamo|Programmer|10-03-2013
523641|Sarah Abraham|Sales & Marketing|03-07-2014
903625|Sammuel Jackson|Technical|15-03-2015
236875|Albert Gonzalez|Programmer|23-05-2014
232212|Gary McKinnon|Programmer|12-01-2013
905863|Jim Carrey|Technical|03-04-2015
A query is needed to group all data by Position as below:-
Accountant
112435 Micheal Angelo 01-02-2015
113254 Adam Sandler 03-02-2015
Programmer
232212 Gary McKinnon 12-01-2013
231564 Adrian Lamo 10-03-2013
235648 Jonathan James 11-03-2013
236875 Albert Gonzalez 23-05-2014
Sales & Marketing
520643 John Abraham 15-06-2014
523641 Sarah Abraham 03-07-2014
526987 Johnny 10-07-2014
Technical
903625 Sammuel Jackson 15-03-2015
905863 Jim Carrey 03-04-2015
Can someone help me on this? I need some guide to do this.