sql乘除
时间: 2023-07-01 20:24:49 浏览: 70
在 SQL 中,乘法和除法运算可以通过使用乘法运算符(*)和除法运算符(/)来实现。
例如,假设我们有一个表格包含商品的价格和数量:
```
CREATE TABLE products (
id INT PRIMARY KEY,
name VARCHAR(50),
price DECIMAL(10,2),
quantity INT
);
INSERT INTO products (id, name, price, quantity)
VALUES
(1, 'Product A', 10.00, 5),
(2, 'Product B', 15.00, 3),
(3, 'Product C', 5.00, 10);
```
我们可以使用乘法运算符来计算每个商品的总价:
```
SELECT name, price * quantity AS total_price
FROM products;
```
输出:
```
+-----------+-------------+
| name | total_price |
+-----------+-------------+
| Product A | 50.00 |
| Product B | 45.00 |
| Product C | 50.00 |
+-----------+-------------+
```
同样地,我们可以使用除法运算符来计算每个商品的单价:
```
SELECT name, price / quantity AS unit_price
FROM products;
```
输出:
```
+-----------+------------+
| name | unit_price |
+-----------+------------+
| Product A | 2.00 |
| Product B | 5.00 |
| Product C | 0.50 |
+-----------+------------+
```