this sqlplus report it's difficult!

Hi
Suppose I have a table with structure and values as following:

CREATE TABLE inc

   (rose varchar2(10));

values:
a
a
b
c
c
c
d
e
f
g
g
g

So, I'd like a sqlplus report like this:

a	2
b	1
c	3
d	1
e	1
f	1
g	3

got it ?        

I could not work it out!!!
Any smart oracle programmer around???
Please, help me writing a select which display an output/report as the one above.
please e-mail to : fn032944_at_flashnet.it thanks
max from rome Received on Fri Feb 05 1999 - 15:19:28 CST