SQL Server
Enviado por Frank Cirilo Escudero • 8 de Mayo de 2023 • Síntesis • 5.727 Palabras (23 Páginas) • 141 Visitas
use taller_SQL
SELECT
*
FROM DBO.TAB_PEDIDO;
SELECT
PD.CODCLI,
PD.NOMCLI,
PD.FECPEDID,
PD.NOMPROD,
PD.MTOVALVTA
FROM DBO.TAB_PEDIDO PD;
use taller_SQL
SELECT
*
FROM DBO.TAB_PEDIDO;
SELECT
PD.CODCLI,
PD.NOMCLI,
PD.FECPEDID,
PD.NOMPROD,
PD.MTOVALVTA
FROM DBO.TAB_PEDIDO PD;
SELECT
PD.CODCLI,
PD.NOMCLI,
PD.FECPEDID,
PD.NOMPROD,
PD.NOMPAIS,
PD.NOMVEND,
PD.MTOVALVTA
FROM DBO.TAB_PEDIDO PD
WHERE PD.FECPEDID >= '20220301' AND
PD.FECPEDID <= '20220331'
AND PD.NOMPAIS = 'México'
AND PD.MTOVALVTA > 1000
AND PD.NOMVEND <> 'Autoventa'
ORDER BY PD.MTOVALVTA DESC;
SELECT
PD.CODCLI,
PD.NOMCLI,
PD.FECPEDID,
PD.NOMPROD,
PD.NOMPAIS,
PD.NOMVEND,
PD.MTOVALVTA
FROM DBO.TAB_PEDIDO PD
WHERE (PD.FECPEDID >= '20220301' AND
PD.FECPEDID <= '20220331')
AND PD.NOMPAIS = 'México'
AND PD.MTOVALVTA > 1000
AND PD.NOMVEND <> 'Autoventa'
ORDER BY PD.MTOVALVTA DESC, PD.FECPEDID;
SELECT
PD.CODCLI,
PD.NOMCLI,
PD.FECPEDID,
PD.NOMPROD,
PD.NOMPAIS,
PD.NOMVEND,
PD.MTOVALVTA
FROM DBO.TAB_PEDIDO PD
WHERE (PD.FECPEDID >= '20220301' AND
PD.FECPEDID <= '20220331')
AND PD.NOMPAIS = 'México'
AND PD.MTOVALVTA > 1000
AND PD.NOMVEND <> 'Autoventa'
ORDER BY PD.MTOVALVTA DESC, PD.FECPEDID;
SELECT
PD.CODCLI,
PD.NOMCLI,
PD.FECPEDID,
PD.NOMPROD,
PD.NOMPAIS,
PD.NOMVEND,
PD.MTOVALVTA AS VALORVENTA,
PD.MTOVALVTA * 0.18 AS IGV,
PD.MTOVALVTA + (PD.MTOVALVTA * 0.18) AS TOTALVENTA
FROM DBO.TAB_PEDIDO PD
WHERE (PD.FECPEDID >= '20220301' AND
...