no rows selected vs. '0' count

Hi, can anyone help me solve this puzzle, please ?

The below query returns no rows.

  select count(*),AVG(DURATN),create_id from mcis_load_time   where to_char(strt_ts)='30-SEP-99' and create_id='1EQHBHAT'   group by create_id

no rows selected

If I remove the create_id from selection list. And also I remove the group by clause then the count(*) returns 0.

   select count(*),AVG(DURATN) from mcis_load_time    where to_char(strt_ts)='30-SEP-99' and create_id='1EQHBHAT'

 COUNT(*) AVG(DURATN)
--------- -----------

        0

Is there any way that I can force the first query to return some value so that I know that "no rows selected".

thanks,

Please email me also at: abhatt_at_shl.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Sep 30 1999 - 10:45:43 CDT