Oracle

subtract 2 column value

Please support our Oracle advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Mar 2009

Posts: 5

Reputation: kazitula is an unknown quantity at this point

Solved Threads: 0

kazitula

Offline

Newbie Poster

subtract 2 column value

Mar 11th, 2009

hi
I have got a table for "internet access" with user ID, it has 3 columns user ID, starttime and endtime, i want to make another column which will show how many mins or hours that user was logged in to the internet and also add the total time if the user logged in more than once. can anyone please help me...
thanks
kaz

•

Join Date: Feb 2007

Posts: 2,146

Reputation: debasisdas will become famous soon enough

Solved Threads: 132

debasisdas debasisdas is offline

Offline

Postaholic

Re: subtract 2 column value

Mar 12th, 2009

i think simple subtract will do that for you.

Share your Knowledge.

•

Join Date: Oct 2009

Posts: 2

Reputation: Juniour is an unknown quantity at this point

Solved Threads: 0

Juniour

Offline

Newbie Poster

Re: subtract 2 column value

Oct 5th, 2009

•

Originally Posted by debasisdas

i think simple subtract will do that for you.

Hi debasisdas,
i also have the same problem and have a mysql table with two columns 'purchases' and 'sales' and would like to have another column 'balance' which is the result of subtracting purchases from sales. I am newbie to MySQL, would you kindly explain more about the simple subtract?

I highly appreciate your help and anyone out there with good ideas.

•

Join Date: Feb 2007

Posts: 2,146

Reputation: debasisdas will become famous soon enough

Solved Threads: 132

debasisdas debasisdas is offline

Offline

Postaholic

Oct 6th, 2009

what you get when you try the following

 Help with Code Tags 
 Oracle Syntax (Toggle Plain Text) 
SELECT purchase,sales,purchase-sales AS balance FROM table_name
select purchase,sales,purchase-sales as balance from table_name