>I have the following code:
>
>
>
>
> select distinct tpi_ind;
> from cdmtpi;
> order bytpi_ind;
> into array aindicators
>And the question is? Do you want to know how many distinct values exist?
select count(distinct tpi_ind)...
Do you want to know how many of each tpi_ind you have?
select tpi_ind, count(*) kount from cdmtpi group by tpi_ind order by tpi_ind ...
If you want only those tpi_ind with a count greater than some value:
select tpi_ind, count(*) kount from cdmtpi group by tpi_ind having kount > 6 order by tpi_ind ...
Mark McCasland
Midlothian, TX USA