Re: Problem query

CS DBA <cs_dba@consistentstate.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