Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT RUTVENDEDOR,
- NOMBRE,
- DIRECCION,
- CODCOMUNA,
- TELEFONO,
- MAIL,
- SUELDO_BASE,
- COMISION
- FROM VENDEDOR
- WHERE ;
- /
- --VENDEDOR CON MAYOR CANTIDAD DE VENTASS EN BOLETAS
- SELECT COUNT(RUTVENDEDOR),
- RUTVENDEDOR
- FROM BOLETA
- GROUP BY RUTVENDEDOR
- HAVING COUNT(RUTVENDEDOR) = (SELECT MAX(COUNT(RUTVENDEDOR))
- FROM BOLETA
- GROUP BY RUTVENDEDOR);
- /
- --SUMA DEL TOTAL VENDIDO POR EL VENDEDOR
- SELECT SUM(TOTAL)
- FROM BOLETA
- GROUP BY RUTVENDEDOR
- HAVING COUNT(RUTVENDEDOR) = (SELECT MAX(COUNT(RUTVENDEDOR))
- FROM BOLETA
- GROUP BY RUTVENDEDOR);;
- /
- --VENDEDOR QUE MAS BOLETAS A REALIZADO Y LA SUMA DEL TOTAL VENDIDO POR ESTE VENDEDOR.
- SELECT COUNT(RUTVENDEDOR),
- RUTVENDEDOR,
- SUM(TOTAL)
- FROM BOLETA
- GROUP BY RUTVENDEDOR
- HAVING COUNT(RUTVENDEDOR) = (SELECT MAX(COUNT(RUTVENDEDOR))
- FROM BOLETA
- GROUP BY RUTVENDEDOR);
- /
- SELECT * FROM DETALLE_FACTURA;
- SELECT * FROM FACTURA;
- SELECT * FROM DETALLE_BOLETA;
- SELECT * FROM BOLETA;
- SELECT * FROM PROMOCION;
- SELECT * FROM PRODUCTO;
- SELECT * FROM UNIDAD_MEDIDA;
- SELECT * FROM PAIS;
- SELECT * FROM CLIENTE;
- SELECT * FROM VENDEDOR;
- SELECT * FROM FORMA_PAGO;
- SELECT * FROM BANCO;
- SELECT * FROM COMUNA;
- SELECT * FROM CIUDAD;
- SELECT * FROM DETALLE_VENTA_MES;
- SELECT * FROM RESUMEN_VENTA_MES;
- SELECT * FROM PAGO_VENDEDOR;
- SELECT * FROM AUDITORIA_PRODUCTO;
- SELECT * FROM PORCENTAJE_COMISION;
- SELECT * FROM ERROR_CALC;
- SELECT * FROM DETALLE_VENTA_MES_VENDEDOR;
- SELECT * FROM AUDIT_PROCESO;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement