A select statement in SQL usually displays column data on a report. At times, however, you might want to display a calculated field on the output. A calculated field is a field whose value is derived from column data.
To learn how calculate fields in a SQL select statement, follow these steps:
+sign (add) and the
*sign (multiplication). I use the
askeyword to give the calculated fields meaningful column headings.