sql算术运算符
SQL | 算术运算符 (SQL | Arithmetic Operators)
Different number-crunching administrators are utilized in SQL to be specific Addition (+), Subtraction (-), Multiplication (*), Division (/), Modulus (%).
SQL中使用了不同的数字运算管理员来表示特定的加法(+),减法(-),乘法(*),除法(/),模数(%) 。
For the further examples we will be referring to the following base table:
对于其他示例,我们将参考以下基础表:
Table: BOOKS
表:书
BookNo | Name | Cost | Discount |
---|---|---|---|
9871 | Nancy Drew | 200 | 5% |
9560 | Goosebump | 250 | 10% |
9810 | Sherlock Holmes | 300 | 15% |
8700 | The Blue Umbrella | 200 | 6% |
5086 | Gulliver Travels | 160 | 4% |
1272 | Hellen Keller | 150 | 4% |
书号 | 名称 | 成本 | 折扣 |
---|---|---|---|
9871 | 南希·德鲁 | 200 | 5% |
9560 | 鸡皮ump | 250 | 10% |
9810 | 夏洛克·福尔摩斯 | 300 | 15% |
8700 | 蓝伞 | 200 | 6% |
5086 | 格列佛游记 | 160 | 4% |
1272 | 海伦·凯勒 | 150 | 4% |
1)加法(+) (1) Addition (+))
It is utilized to perform addition procedures on the information things, things incorporate either single section or different segments.
它用于对信息事物执行附加过程,这些事物包含单个部分或不同的段。
Implementation:
实现方式:
SELECT bookno, name, cost, discount, cost+50 AS "Final Cost"
FROM BOOKS;
Output
输出量
BookNo | Name | Cost | Discount | Final Cost |
---|---|---|---|---|
9871 | Nancy Drew | 200 | 5% | 250 |
9560 | Goosebump | 250 | 10% | 300 |
9810 | Sherlock Holmes | 300 | 15% | 350 |
8700 | The Blue Umbrella | 200 | 6% | 250 |
5086 | Gulliver Travels | 160 | 4% | 210 |
1272 | Hellen Keller | 150 | 4% | 200 |
书号 | 名称 | 成本 | 折扣 | 最终成本 |
---|---|---|---|---|
9871 | 南希·德鲁 | 200 | 5% | 250 |
9560 | 鸡皮ump | 250 | 10% | 300 |
9810 | 夏洛克·福尔摩斯 | 300 | 15% | 350 |
8700 | 蓝伞 | 200 | 6% | 250 |
5086 | 格列佛游记 | 160 | 4% | 210 |
1272 | 海伦·凯勒 | 150 | 4% | 200 |
Similarly, we can do the addition of two columns too.
同样,我们也可以添加两列。
2)减法(-) (2) Subtraction (-))
It is utilized to perform subtraction procedures on the information things, things incorporate either a single section or different segments.
它用于对信息事物执行减法过程,信息包含单个部分或不同的段。
Implementation:
实现方式:
SELECT bookno, name, cost, discount, cost-discount AS "Final Cost"
FROM BOOKS;
Output
输出量
BookNo | Name | Cost | Discount | Final Cost |
---|---|---|---|---|
9871 | Nancy Drew | 200 | 12.50 | 237.50 |
9560 | Goosebump | 250 | 30.00 | 270.00 |
9810 | Sherlock Holmes | 300 | 52.50 | 297.50 |
8700 | The Blue Umbrella | 200 | 15.00 | 235.00 |
5086 | Gulliver Travels | 160 | 8.40 | 201.6 |
1272 | Hellen Keller | 150 | 8.00 | 192.00 |
书号 | 名称 | 成本 | 折扣 | 最终成本 |
---|---|---|---|---|
9871 | 南希·德鲁 | 200 | 12.50 | 237.50 |
9560 | 鸡皮ump | 250 | 30.00 | 270.00 |
9810 | 夏洛克·福尔摩斯 | 300 | 52.50 | 297.50 |
8700 | 蓝伞 | 200 | 15.00 | 235.00 |
5086 | 格列佛游记 | 160 | 8.40 | 201.6 |
1272 | 海伦·凯勒 | 150 | 8.00 | 192.00 |
3)乘法(*) (3) Multiplication (*))
It is utilized to perform multiplication procedures on the information things, things incorporate either a single section or different segments.
它用于对信息事物执行乘法过程,这些事物包含单个节或不同段。
Implementation:
实现方式:
SELECT bookno, name, cost, discount, cost*discount AS "Final Cost"
FROM BOOKS;
Output
输出量
BookNo | Name | Cost | Discount | Final Cost |
---|---|---|---|---|
9871 | Nancy Drew | 200 | 12.50 | 2500 |
9560 | Goosebump | 250 | 30.00 | 7500 |
9810 | Sherlock Holmes | 300 | 52.50 | 15750 |
8700 | The Blue Umbrella | 200 | 15.00 | 3000 |
5086 | Gulliver Travels | 160 | 8.40 | 1344 |
1272 | Hellen Keller | 150 | 8.00 | 1200 |
书号 | 名称 | 成本 | 折扣 | 最终成本 |
---|---|---|---|---|
9871 | 南希·德鲁 | 200 | 12.50 | 2500 |
9560 | 鸡皮ump | 250 | 30.00 | 7500 |
9810 | 夏洛克·福尔摩斯 | 300 | 52.50 | 15750 |
8700 | 蓝伞 | 200 | 15.00 | 3000 |
5086 | 格列佛游记 | 160 | 8.40 | 1344 |
1272 | 海伦·凯勒 | 150 | 8.00 | 1200 |
4)师(/) (4) Division (/))
It is utilized to perform division procedures on the information things, things incorporate either a single section or different segments.
它用于对信息事物执行划分过程,信息包含单个部分或不同的段。
Implementation:
实现方式:
SELECT bookno, name, cost, discount, cost/discount AS "Final Cost"
FROM BOOKS;
Output
输出量
BookNo | Name | Cost | Discount | Final Cost |
---|---|---|---|---|
9871 | Nancy Drew | 200 | 12.50 | 16.00 |
9560 | Goosebump | 250 | 30.00 | 8.33 |
9810 | Sherlock Holmes | 300 | 52.50 | 5.71 |
8700 | The Blue Umbrella | 200 | 15.00 | 13.33 |
5086 | Gulliver Travels | 160 | 8.40 | 19.04 |
1272 | Hellen Keller | 150 | 8.00 | 18.75 |
书号 | 名称 | 成本 | 折扣 | 最终成本 |
---|---|---|---|---|
9871 | 南希·德鲁 | 200 | 12.50 | 16.00 |
9560 | 鸡皮ump | 250 | 30.00 | 8.33 |
9810 | 夏洛克·福尔摩斯 | 300 | 52.50 | 5.71 |
8700 | 蓝伞 | 200 | 15.00 | 13.33 |
5086 | 格列佛游记 | 160 | 8.40 | 19.04 |
1272 | 海伦·凯勒 | 150 | 8.00 | 18.75 |
5)模量(%) (5) Modulus (%))
This operator is used to get the remainder when the division operation is performed with the data.
当对数据执行除法运算时,该运算符用于获取余数。
Implementation:
实现方式:
SELECT bookno, name, cost, discount, cost%discount AS "Final Cost"
FROM BOOKS;
Output
输出量
BookNo | Name | Cost | Discount | Final Cost |
---|---|---|---|---|
9871 | Nancy Drew | 200 | 12.50 | 0 |
9560 | Goosebump | 250 | 30.00 | 10 |
9810 | Sherlock Holmes | 300 | 52.50 | 37.5 |
8700 | The Blue Umbrella | 200 | 15.00 | 5 |
5086 | Gulliver Travels | 160 | 8.40 | 0.4 |
1272 | Hellen Keller | 150 | 8.00 | 6 |
书号 | 名称 | 成本 | 折扣 | 最终成本 |
---|---|---|---|---|
9871 | 南希·德鲁 | 200 | 12.50 | 0 |
9560 | 鸡皮ump | 250 | 30.00 | 10 |
9810 | 夏洛克·福尔摩斯 | 300 | 52.50 | 37.5 |
8700 | 蓝伞 | 200 | 15.00 | 5 |
5086 | 格列佛游记 | 160 | 8.40 | 0.4 |
1272 | 海伦·凯勒 | 150 | 8.00 | 6 |
翻译自: https://www.includehelp.com/sql/arithmetic-operators.aspx
sql算术运算符