In line queries......

Picture the scene,

I have a SUBSCRIBERS table thus

SUBS_ID            number(8)
SUBS_TYPE      varchar2(3)
SUBS_START    date
SUBS_END        date

I am wanting to run a query which will give me a count of all active and cancelled subscriptions by type. An active subscription is one with a NULL SUBS_END date and cancelled is one with a SUBS_END date.

Have been trying in-line views to no avail.

All help greatly appreciated. Received on Thu Mar 09 2006 - 09:43:25 CST