View Single Post
  #3 (permalink)  
Old May 28th, 2007, 04:14 AM
rupen rupen is offline
Registered User
Points: 1,897, Level: 17
Points: 1,897, Level: 17 Points: 1,897, Level: 17 Points: 1,897, Level: 17
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2005
Location: Mumbai, Maharastra, India.
Posts: 352
Thanks: 14
Thanked 0 Times in 0 Posts
Send a message via Yahoo to rupen
Default

Thanks for the reply!!!
Query - "Select sum(lct)/sum(amt) from table1"
data should be in real number with 2 to 4 digit of decimal,
it dosen't shows any data it gives this error and terminates.

I guess it gives around 12 to 15 digit after decimal point and hence creates problem.

Rupen Anjaria.:)
------------------
We CAN'T avoid problems, but can solve it.