SQL - Structured Query Language

SELECT - Expression of Column(s)

SQL Server allows you to calculate collection of column(s) by using + operator. This operator is used to calculate two or many Numeric or Date data type column(s). An example, the following queries are used to displays calculated column(s) records from PRODUCT Table.

-- Example 22 --


SELECT Exp_Date, Exp_Date + 15 AS 'New Exiry Date' FROM Product


SELECT Prod_Tax, Prod_Tax + 5 AS 'New Product Tax' FROM Product

Query Output Screen

* * * * *

Email Your Comment To AUTHOR