MySQL QUERY (group)

[rhyandiansay]

hello,

i want to query in my database by group (department).
and i want to display in different table each department .

output:

---

department one

1 abc
2 def
3 ghi

---

department two

1 abc
2 def
3 ghi

…
thank you so much…