Suppose you have a table T with columns Column1 and Column2. The following code will create a new column named Column3 with the difference of Column1 and Column2.
main.m35 chars2 lines
You can also subtract a scalar value from a column like this:
main.m28 chars2 lines
Note that this will subtract 10 from each element of Column1 and create a new column Column3 with the result.
gistlibby LogSnag