Re: OCI Problem - HELP
From: Furs Sergei <sef_at_bank.kemerovo.su>
Date: Fri, 11 Mar 94 09:20:07 +0700
Message-ID: <199403110935.AA06050_at_odb-gw.bank.kemerovo.su>
Date: Fri, 11 Mar 94 09:20:07 +0700
Message-ID: <199403110935.AA06050_at_odb-gw.bank.kemerovo.su>
jcrupi_at_mystech.mystech.com writes:
>I would like to know how to get the number of records which
>meet a multiple field distinct clause. ie.
>
>Select distinct name, division, title from company_table;
>
>But I can't do this :
>
>Select COUNT( distinct name, division, title ) from company_table;
>
>I am using OCI. Thanks. jcrupi_at_mystech.com
>
Try do this:
Select COUNT( distinct name||division||title ) from company_table;
If name,division,title is character fields. If not character, then use TO_CHAR() function.
Serge Furs. Received on Fri Mar 11 1994 - 03:20:07 CET