what do you want to see?

Try this:

create table p

(name char(10)

,n int)

insert into p

select 'AA',10 union all

select 'AA',12 union all

select 'AA',4 union all

select 'BB',11 union all

select 'CC',51 union all

select 'CC',33

select

cast(name as varchar(20)) as r

...