Iniciar sesión
Crear cuenta
Crear cuentaCrear cuenta
mysql> SELECT 7 DIV 3;+---------+
| 7 DIV 3 |
+---------+
| 2 |
+---------+
1 row in set (0.02 sec)
mysql> SELECT 105 DIV 100;+-------------+
| 105 DIV 100 |
+-------------+
| 1 |
+-------------+
1 row in set (0.01 sec)
mysql> SELECT * FROM t_contratos;
+--------+--------+--------+
| campo1 | campo2 | campo3 |
+--------+--------+--------+
| 1 | 1 | 80 |
| 2 | 1 | 105 |
| 3 | 1 | 60 |
| 4 | 2 | 205 |
| 5 | 2 | 299 |
| 6 | 2 | 300 |
+--------+--------+--------+
4 rows in set (0.00 sec)
mysql> SELECT-> campo1,
-> campo2,
-> campo3,
-> (campo3 DIV 100 + 1) total_ventas
-> FROM t_contratos;
+--------+--------+--------+--------------+
| campo1 | campo2 | campo3 | total_ventas |
+--------+--------+--------+--------------+
| 1 | 1 | 80 | 1 |
| 2 | 1 | 105 | 2 |
| 3 | 1 | 60 | 1 |
| 4 | 2 | 205 | 3 |
| 5 | 2 | 299 | 3 |
| 6 | 2 | 300 | 4 |
+--------+--------+--------+--------------+
4 rows in set (0.00 sec)
select cod_comisionista,sum ( (select nventas from te_tramos
where te_contrato.total <= te_tramos.maximo
limit 1)) as NVentas
from te_contrato
where fec_venta between '20170601' and '20170630'
group by cod_comisionista_v