SQL Server
Frank Cirilo EscuderoSíntesis8 de Mayo de 2023
5.727 Palabras (23 Páginas)167 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
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.NOMESTADO,
PD.NOMCIUDAD,
PD.NOMPAIS + ' - ' + PD.NOMESTADO +' - ' + PD.NOMCIUDAD AS UBICACION,
PD.NOMVEND,
PD.MTOVALVTA AS VALORVENTA,
PD.MTOVALVTA * 0.18 AS IGV,
PD.MTOVALVTA + (PD.MTOVALVTA * 0.18) AS TOTALVENTA,
PD.MTOVALVTA * 1.18 AS TOTALVENTA2
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.NOMESTADO,
PD.NOMCIUDAD,
PD.NOMPAIS + ' - ' + PD.NOMESTADO +' - ' + PD.NOMCIUDAD AS UBICACION,
PD.NOMVEND,
PD.MTOVALVTA AS VALORVENTA,
PD.MTOVALVTA * 0.18 AS IGV,
PD.MTOVALVTA + (PD.MTOVALVTA * 0.18) AS TOTALVENTA,
...