Hi,

instead using all the columns in the group by clause, you can use aggregate function "OVER BY " in the query............

OR

give me the details of the output what u want.....