Sql 2
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Sql 2 as PDF for free.
More details
- Words: 73
- Pages: 1
Consultas Compras Nombre articulo, dni, valor compra, fecha SELECT art.concepto, c.dni, (c.cantidad*art.pvp) as valor_compra, c.fecha FROM articulos art, compras c WHERE art.numero=c.numero Num art, nº productos comprados SELECT numero, SUM(cantidad) FROM compras GROUP BY numero
Articulo comprado y costo total
SELECT c.numero, SUM(c.cantidad*art.pvp) FROM compras c, articulos art where art.numero=c.numero GROUP BY c.numero
Pero aqui aparece el nombre del articulo
SELECT art.concepto, SUM(c.cantidad*art.pvp) FROM compras c, articulos art where art.numero=c.numero GROUP BY art.concepto
Articulo comprado y costo total
SELECT c.numero, SUM(c.cantidad*art.pvp) FROM compras c, articulos art where art.numero=c.numero GROUP BY c.numero
Pero aqui aparece el nombre del articulo
SELECT art.concepto, SUM(c.cantidad*art.pvp) FROM compras c, articulos art where art.numero=c.numero GROUP BY art.concepto
