Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT *, sum(total) as vendas, sum(quantidade) as totalquantidade, (totalquantidade*precovenda)-(quantidade*precocompra) as lucro
- FROM pedidos
- WHERE idcaixa = buscar
- GROUP BY produto
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement