group clauses

[jansky]

to all guru
im trying to display a result in my table in a group how can i do tha?
eg:
fielda | fieldb |
a c
a d
e a
f g

[Kudose]

http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html