Re: (no subject)

On Mon, 2003-09-15 at 09:29, Prakash Jattani wrote:
> hi thomas,
>  
> sorry to bother you again but i am still having 2 more problems. it
> would be grateful if you help me out.
>  
> 1. The query below is selecting the max value from the table. The
> table can be blank so it will return me a null value which i need to
> set to 0. How do i do it?

select decode (max(i),NULL,0,max(i)) from myTable