Re: HELP! Oracle Error

Jee Myeong Ku (jku) wrote:
: I get an oracle divide by zero error when I type the following SQL command:
:
: select * from sales where cost / quantity > 0.5
:
: The reason is that there is at least one row in the sales table where
: the value of the field quantity is 0.
:
: Does anyone know a way to get around this problem without using views
: or nested queries?

select * from sales where cost /quantity > 0.5 and quantity <> 0

Joe

:
: Jee Ku
:
 

-- 
                                   
=------------------------------------------------------------------------=
Joe Nardone               |    
joe_at_access.digex.net      |