Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> sql problem/question

sql problem/question

From: Peter Shankey <shankeyp_at_charlestoncounty.org>
Date: Sun, 23 Jan 2000 07:46:19 -0500
Message-ID: <388AF81A.CE86F1BF@charlestoncounty.org> 





A table has distinct values in column 1 (c1) how can I count the number
of rows each distinct value has. I am looking for something like


c1          number of rows
---         ---
v1         25
v2         100
v3          20
v4          500






Thanks


Pete

Received on Sun Jan 23 2000 - 06:46:19 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US