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

Home -> Community -> Usenet -> c.d.o.tools -> Need help with query

Need help with query

From: Bob McConnell <bob.mcconnell_at_mci.com>
Date: Thu, 14 Dec 2000 19:23:38 GMT
Message-ID: <3A391F2A.64405B60@mci.com>

Hi,
I have a table with 3 fields and I need to count the data without reguard to the field it is in.

field1 filed2 field3

 a         b        c
 d         c        a
 e         a        a

I need to report that the count is
a 4
b 1
c 2
d 1
e 1

Is this possible??

thanks,
 Bob Received on Thu Dec 14 2000 - 13:23:38 CST

Original text of this message

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