I suggest you look at the group by clause in the docs at http://tahiti.oracle.com