Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Posts
    11

    SQl query for subtracting one column from the other

    What is the SQL query to subtract one column from the other?

  2. #2
    Join Date
    May 2002
    Posts
    1
    Assuming that your query was
    SELECT KEYFIELD, VALUE1, VALUE2 FROM TABLENAME
    and you wanted a 4th column containing Value1 less Value2, you could try
    SELECT KEYFIELD, VALUE1, VALUE2, VALUE1-VALUE2 AS DIFFERENCE FROM TABLENAME.

    If your question meant something else, please clarify.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •