CS DBA <cs_dba(at)consistentstate(dot)com> wrote:
> The app wants to run a query like this:
>
> select count(pri_num) from max_xtrv_st_t
> where pri_num in (select max(pri_num) from max_xtrv_st_t where 1=1
> group by tds_cx_ind, cxs_ind_2)
Why not something simpler? There are a number of possibilities, and
I don't claim this one is necessarily best (or even error free), but
how about something like?:
select count(*) from
(select distinct max(pri_num)
from max_xtrv_st_t
group by tds_cx_ind, cxs_ind_2) x
-Kevin