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