|
|
|
| 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 |
* * * * *
|
|
|
|
Copyrights © . Data-e-Education. All Rights Reserved.
Your Comment To AUTHOR