Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to query for total days?
In article <pan.2002.10.16.17.48.43.779.3233_at_willets.org>, "Kendall
Willets" <kendall_at_willets.org> wrote:
Oops, that should be count(distinct dt).
> select member_id, count(*)
> from the_first_table i, sept_days d
> where d.dt between i.eff_dt and i.term_dt group by member_id
Received on Wed Oct 16 2002 - 20:04:23 CDT