How to divide two decimal values in a SELECT query

muthukannan · New User Joined: 03 Aug 2006 Posts: 42 Location: Chennai

Hi,

Can someone please explain how to divide two decimal values in a SELECT query. When i did so i got a sql code as -802.

If you can please post a sample query also.

Thanks in advance.

Thanks,
Mk

dbzTHEdinosauer · Posted: Thu Aug 30, 2007 12:41 pm

muthukannan,

show us your query. If you had looked up -802, you would find that the reasons include data - divide by zero -

any SQL manual will provide an example.

SELECT A
FROM TABLE
WHERE B/4 > C

muthukannan · New User Joined: 03 Aug 2006 Posts: 42 Location: Chennai

Hi,

The following is the sample query.

select ((cola/colb) * 100) from table

In this cola and colb are decimal

Thanks,
Mk

amitava · Active User Joined: 30 Oct 2005 Posts: 186 Location: India

Hey muthukannan, U r doing something wrong in the query. The query should work and also for clarifying the scenario I checked in my system. My query was like -

muthukannan · New User Joined: 03 Aug 2006 Posts: 42 Location: Chennai

Hi Amitava,

Can you please use the denominator also as a decimal value.
can you please check that and tell me.

Thanks
Mk

dbzTHEdinosauer · Posted: Thu Aug 30, 2007 4:39 pm

I would utilize a WHERE clause to exclude colb = 0. If either cola or colb could be NULL, I would include that condition in my WHERE clause also.

amitava · Active User Joined: 30 Oct 2005 Posts: 186 Location: India

Hey man! When it is working with integer, it should work with decimal also! However, I have checked also and it is working fine.

amitava · Active User Joined: 30 Oct 2005 Posts: 186 Location: India

Wah! dbzTHEdinosauer has given a very good suggestion just like a Dinosauer. Hey I am joking! Pls don't mind. Yop muthukannan check whether the colb is not zero and not null. Only then ur query can not work.

muthukannan · New User Joined: 03 Aug 2006 Posts: 42 Location: Chennai

Hi Amitava,

The query is working fine.

Thanks,
Mk