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 -> Re: Query Problem

Re: Query Problem

From: Conan <conan_at___no-spam__dublin.com>
Date: Mon, 27 Nov 2000 10:54:51 -0000
Message-ID: <h4rU5.1081$Er5.530@news.indigo.ie>

hi Ted
use

select x, count(distinct y)
from table
group by x

HTH
Conan Received on Mon Nov 27 2000 - 04:54:51 CST

Original text of this message

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