Multiplying Two Columns in SQL Server

Question

How can I perform operations such as Multiplying and Subtracting two columns in SQL Server   Payment PK - PaymentID FK - PaymentTypeID FK - OccupiedApartmentID      - InitalPayment    - MonthlyRate    - Balance      - PaymentDate

User · Answer

select InitialPayment   MonthlyPayRate as SomeRandomCalculation from Payment

User · Answer

In a query you can just do something like   SELECT ColumnA   ColumnB FROM table   or  SELECT ColumnA - ColumnB FROM table   You can also create computed columns in your table where you can permanently use your formula

User · Answer

This code is used to multiply the values of one column  select exp sum log column    from table

User · Answer

select InitialPayment   MonthlyRate as MultiplyingCalculation  InitialPayment - MonthlyRate as SubtractingCalculation from Payment

User · Answer

Syntax   SELECT  lt Expression gt  Arithmetic Operator  lt expression gt      FROM  Table Name    WHERE  expression      Expression   Expression made up of a single constant  variable  scalar function  or column name and can also be the pieces of a SQL query that compare values against other values or perform arithmetic calculations  Arithmetic Operator   Plus     minus -   multiply     and divide     Table Name   Name of the table

[sql] Multiplying Two Columns in SQL Server

Examples related to sql

Examples related to sql-server