Structure SQL Output

[rene.heusser]

I would like to know how I need to setup the query
"select anumber, acharacter from atable order byanumber, acharacter"
which results in:
Anumber Acharacter
1 A
1 B
1 C
2 A
2 B

To look like:
Anumber Acharacter
1 A
B
C
2 A
B
C
So that the repeating values are suppressed.
Thanks for any hint.
Ren

 

[gulhaugen]

It's not for this forum..
select (case
when lag(anumber) over(order by anumber) = anumber then
null
else
anumber
end), acharacter from atable order by anumber, acharacter