Shaun Thomas <sthomas@peak6.com> wrote:
> You're counting the number of maximum values in your table for
> tds_cx_ind and cxs_ind_2, but there will always be at least one
> for every combination.
Good point.
> What you really want is this:
>
> SELECT count(1) FROM (
> SELECT DISTINCT tds_cx_ind, cxs_ind_2
> FROM max_xtrv_st_t
> );
Or maybe:
SELECT count(DISTINCT (tds_cx_ind, cxs_ind_2)) FROM max_xtrv_st_t;
-Kevin