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 -> Re: Count?

Re: Count?

From: JoeZ53 <joez53_at_aol.com>
Date: 17 May 1999 19:05:01 GMT
Message-ID: <19990517150501.21440.00002658@ng-fi1.aol.com>


Try

select t1.field1, count(*)
  from table_1 t1,

           table_2 t2
 where t2.field15 like '%'||t1.field1||'%' group by t.field1 Received on Mon May 17 1999 - 14:05:01 CDT

Original text of this message

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