Computing percentage change between tables
Date: Mon, 20 Jul 2009 01:35:21 -0700 (PDT)
I'm a novice to sql scripting. Am trying to figure out a design problem, involving some arithmatic computation.
I have two tables temp1 and temp2 with two feilds
account no., ( Common in both tables )
balance ( float data type ).
- I want to compare the balance feilds in temp1 and temp2. print out the no. of accounts and percentage of match and mismatch.
- output the a/c nos. whose balances dont match into a seperate table..
another question, that I have is, how does sql handle the computation, if a value in a particular field is divided by 0 ?
any help, will get me started.
thanks Received on Mon Jul 20 2009 - 03:35:21 CDT